Performance Optimization – How to Get the Best Out of Your Indexes on Postgres and MySQL

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. Speaker: Charly Batista – Percona