February 23-25, 2022
Montreal, Canada

Real-life Database Indexing.

Indexes are one of the most essential components of relational databases, and one of the least well-understood by many application developers. They are critical for good database performance, but they are not a magic "go-faster" button. This talk goes over different kinds of indexes, how they help various specific types of queries, and when you shouldn't use indexes in the first place. The example database will be PostgreSQL.

View all 157 sessions

Christophe Pettus

PostgreSQL Experts, Inc.

Christophe is the CEO and lead consultant at PostgreSQL Experts, Inc., a boutique PostgreSQL consultancy. He has been doing database stuff since the mid-1990s, and has been programming for an exceptionally long time before that.

Read More