Christophe Pettus

Christophe Pettus

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.

Montreal 2022 sessions

Database Antipatterns and Where to Find Them

English session - Intermediate

When building an application on top of a relational database, it's very easy to fall into antipatterns that can cause the application to perform poorly as it scales… or when you first turn it on! The scope of this talk is talking about the most common ways in which applications abuse databases, and how to address them early in development so you are not struggling later. We'll use PostgreSQL for examples, but the information isn't exclusive to it

Real-life Database Indexing.

English session - Intermediate

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.