Around the world with Postgres extensions

Postgres continues to get more and more feature rich. But equally as impressive is the network of extensions that are growing around Postgres. With the rich extension APIs you can now add advanced functionality to Postgres without having to fork the codebase or wait for the main PostgreSQL release cycle. In this talk we'll cover some of the basics of what an extension is and then take a tour through a variety of Postgres extensions including:

• pg_stat_statments
• PostGIS
• HyperLogLog and TopN
• Timescale
• pg_partman
• Citus
• Foreign data wrappers which are their own whole class