Presented by:

Charly batista 2

Charly Batista

Percona LLC

Charly is the PostgreSQL Tech Lead at Percona and is passionate about databases and performance. He has been working with databases and development for over 20 years and has participated in many projects, from the design of a small sensor to count how many times a ball passes through a basketball hoop to complex database proxy applications.

Outside work, he loves sports, as a good Brazilian he practices football (or soccer), volleyball, and surprisingly ping-pong. Charly is also passionate about new cultures, their languages, and traditions, and has lived and/or worked in a few different countries. Today he basically lives between Brazil and China. Not really in between, but stays some time in Brazil and some time in China :D

No video of the event yet, sorry!

Sometimes, PostgreSQL struggles with slow queries. Indexing might help, but it’s important to use the right strategies. In this talk, we’ll explore how advanced indexing can speed up your queries. We'll quickly review the B-Tree and Hash indexes, but the focus will be less common index strategies like the BRIN, GIN, and GiST indexes.

We’ll start by explaining what B-Tree, Hash, BRIN, GIN, and GiST indexes are, how they work, and when to use them. You’ll see real examples showing how these indexes can improve query performance. However, we’ll also discuss why indexes aren’t a magic fix for all problems. Using indexes effectively requires good planning and strategy.

By the end of this session, you’ll know how to choose and use the right indexes to make your PostgreSQL queries faster and more efficient. Whether you’re a developer or a database administrator, you’ll gain valuable insights to help you optimize your database performance.

Join us to learn how advanced indexing can boost your PostgreSQL performance and the strategies needed to make them work best!

Date:
2025 March 21 15:00 EDT
Duration:
50 min
Room:
Space Coast 3
Conference:
Postgres Conference 2025
Language:
Track:
Ops
Difficulty:
Medium