PostgreSQL: Extensions Shape the Future

Ryan Lambert

Data problems often involve creative solutions, and Postgres extensions are up for the challenge! A key feature of Postgres is that it was designed with extensibility in mind. All that is needed to unlock additional features is a CREATE EXTENSION command. This session covers the reasons why I continue to be impressed by what Postgres can do, and why I am excited about its future!

The ability to install custom, third-party extensions is a key reason Postgres continues to increase in popularity. Extensions can hook into the inner workings of Postgres to provide everything from simple convenience functions to completely changing how Postgres operates. Examples of current extensions include PostGIS (geospatial), TimescaleDB (timeseries), PostgresML (ML/AI), and Citus (sharding). These extensions illustrate the incredible range of functionality available through Postgres.

The long history Postgres has with extensions provides a foundation of trust and excitement in the community. That excitement has manifested with improvements in the extension development space. One prominent example is the pgrx framework, which makes it easy to develop new Postgres extensions using the Rust language. When it is easy to try out new ideas, innovation flourishes!