Flexible Indexing with Postgres

Explore the diverse world of Postgres indexing structures and data-type-specific lookup methods in this comprehensive conference talk. Delve into the efficiency of brin indexing for multiple columns, the specialization of gin indexing for rapid key lookup with numerous duplicates, and the advantages of GiST indexing for two-dimensional values and range types. Learn when and how to leverage these various indexing features to optimize database performance, particularly in scenarios involving json and full text searching. Gain valuable insights into the strengths and applications of different indexing techniques, building upon foundational knowledge of non-relational Postgres concepts.

PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian