PostgreSQL Indexes demystified — Charly Batista, Percona

This 3 hours tutorial that will walk you through the PostgreSQL indexes including B-Tree, Hash, GIN, GiST, and BRIN indexes, We'll review their concepts, implementation, and review the Postgres HEAP implementation to have a good understanding on how to use the indexes to improve database performance. We will also understand how to use the EXPLAIN to check the optimizer plans to see if the indexes we create are used, understand why it may not be used, and some tips on how to "force" Postgres to use them.

#perconalive #postgresql