Welcome to Percona Live Online 2021
Online Open Source Database Conference
Wednesday, May 12 • 10:00 - 11:00
Power Use of Indexes in PostgreSQL - A User Perspective.

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.

There have been many presentations about the Different Indexes in PostgreSQL ( B-Tree, HASH, GIN, GiST etc), especially from the PostgreSQL architecture perspective.

But these talks always lacked details from the user perspective on the selection of indexes.

It is common to see that architects and developers fail to select the right types of index and the way it should be used. Just an overview of all types of indexes also won't help much in decision-making. In this talk, I am covering the following points also.

1. Index when partitioning is not an option.
2. 2. Inverted Indexes and their usefulness in the real world.
3. 3. Tips and techniques for efficient index usage.
4. 4. How important is Index usage monitoring and how to do that.

This talk is more towards proper examples and demonstrations. This presentation with demonstrations is expected to drive users to the right selection of indexes and better usage

avatar for Sergey Kuzmichev

Sergey Kuzmichev

Support Engineer, Percona
Sergey is a support engineer in Percona. Interested in all things databases, he's currently working mainly with MySQL and PostgreSQL. He started his career working as an Oracle DBA, later moving to a DevOps engineer role supporting a Java-based trading platform running on PostgreSQL... Read More →
avatar for Jobin Augustine

Jobin Augustine

PostgreSQL Escalation Specialist, Percona
Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 19 years of working experience as consultant, architect, administrator, writer, and trainer in PostgreSQL, Oracle and other database technologies. He has always been an active participant in the Open... Read More →

Wednesday May 12, 2021 10:00 - 11:00 EDT
Room #3