Map of Amazing Postgres Extensions

Claire Giordano

Postgres extensions are everywhere–and are found in lots of 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. If you’re new to Postgres, you might be wondering “What is a Postgres extension?” If you’re familiar with Postgres, you might still wonder: “Where do I find all the extensions? Can I trust them? Which Postgres extensions will make my life better and save me time?”

In this updated version of a talk I first gave at PGConf NYC, I’ll walk you through the set of amazing Postgres extensions I’ve learned about in my ~8 years working in the world of Postgres: what they are, why care about them, 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 over 20 lesser-known (or favorite) extensions which are quite handy, too.

This talk includes a brief detour into the history of Postgres extensions, and 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.

For the presentation slides, copy and paste the following link: https://speakerdeck.com/clairegiordano/map-of-amazing-postgres-extensions-you-might-not-know-about-claire-giordano-pass-data-summit-2024