Schedule - PGDay Chicago 2024

Map of Amazing Postgres Extensions You Might Not Know About

Date: 2024-04-26
Time: 09:45–10:30
Room: Hub2
Level: Beginner

Postgres extensions are everywhere—and are found in oh so many Postgres deployments. You might even say that PG extensions are the tools that make your Postgres toolbox complete.

But navigating the world of PG extensions can be a challenge. Where do you find all the extensions? Which Postgres extensions can make your life better and save you time? Which ones should you consider using? Can you trust them?

This talk walks you through the set of amazing Postgres extensions I’ve learned about in my ~7 years working in the world of Postgres: what they are, why care, and where to find them. You’ll learn about popular extensions like pg_stat_statements, "super extensions" such as PostGIS and Citus—as well as 25 lesser-known extensions that are quite handy, too.

This talk includes a brief detour into the history of Postgres extensions, plus a glimpse into the future of extensions (spoiler: will they be built with Rust?) By the end of this talk, you’ll have a “map” of the world of amazing Postgres extensions—plus a legend and compass for figuring out which extensions can help you and your application.


Claire Giordano