PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=76akfLDQVJs


Duration: 49:14
51 views
0

Flexible Indexing with Postgres by Bruce Momjian

When considering database indexing, many people are confused by the many Postgres indexing structures available, and the many data-type-specific index lookup methods. For example, brin allows for efficient indexing of many columns. gin indexing specializes in the rapid lookup of keys with many duplicates — an area where traditional btree indexes perform poorly. This is particularly useful for json and full text searching. GiST allows for efficient indexing of two-dimensional values and range types. This talk explores the various indexing features of Postgres and when to use them. This is ideal when presented after my Non-Relational Postgres presentation.



Other Videos By Confreaks


2022-10-12PGConf NYC 2021 - Identifying Slow Queries and Fixing Them! by Stephen Frost
2022-10-12PGConf NYC 2021 - PostgreSQL Query Performance Insights by Hamid Quddus Akhtar
2022-10-12PGConf NYC 2021 - Advanced Data Types in PostgreSQL by Andreas Scherbaum
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Speaking and Community Involvement for the Introvert by Pat Wright
2022-10-12PGConf NYC 2021 - Get Your Insecure PostgreSQL Passwords to SCRAM! by Jonathan S. Katz
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Navigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaS by Marc Linster
2022-10-12PGConf NYC 2021 - How we made PG Fitter, Happier, More Productive by Andrew Atkinson
2022-10-12PGConf NYC 2021 - War Stories: Fighting the PostreSQL Support Trenches by Hans Jurgen
2022-10-12PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian
2022-10-12PGConf NYC 2021 - A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
2022-10-12PGConf NYC 2021 - PostgreSQL sharding, state of the art by Julien Tachoires
2022-10-12PGConf NYC 2021 - Teaching elephants to fish by Ryan Booz
2022-10-12PGConf NYC 2021 - Migration validation made easy with Ora2Pg by Gilles Darold
2022-10-12PGConf NYC 2021 - Chasing unicorns : 0 dataloss and 99.999% availability by Laetitia Avrot
2022-10-12PGConf NYC 2021 - Evolution Of PostgreSQL Replication and High Availability... by Stacy Scoggins
2022-10-12PGConf NYC 2021 - Pglog: a flexible log analyser by Laetitia Avrot
2022-10-12PGConf NYC 2021 - When it all GOes right by Pavlo Golub
2022-10-12PGConf NYC 2021 - Data Security using Roles, Privileges and Row Level Security by Abbas Butt
2022-10-12PGConf NYC 2021 - Postgres and Json - How to get the best of them? by Charly Batista