Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Thursday, May 13 • 08:00 - 09:00
Performance Optimization - How to Get the Best Out of Your Indexes on Postgres and MySQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

During this talk we will discuss how the index works on Postgres and MySQL. What are the differences between the implementations and what are the more appropriate choices for different scenarios? We will discuss the general B+-tree indexes but also discuss GIN, GIST and understand where they are best suited with examples and understand why some database migrations are a failure due to differences in implementation or lack of a specific index.

avatar for Charly Batista

Charly Batista

PostgreSQL Tech Lead, Percona
A Brazilian living in China... Charly is passionate about new cultures, their languages and traditions. Charly has been working with database and development for more than 15 years and has participated in small and large projects in Brazil, the US, China, and other countries. Currently... Read More →

Thursday May 13, 2021 08:00 - 09:00 EDT
Room #3