State of the Postgres Extension Ecosystem
summary
Postgres extensions remain scattered but momentum is clear: PGXN hosts ~400 extensions (369 distributions) while community inventories list ~1,200 public projects; cloud providers expose 25–48 curated extensions (Azure 25, GCP 29, AWS 48). New tools actually built include PGRX for Rust extensions, pg_tle/TLEs for SQL-and-trusted-language installs, and binary registries like Trunk (pgt.dev) and pgxman that produce prebuilt packages and stats. A proposed PGXN V2 ties a root registry, interactions stream, and binary packagers so users get discoverable metadata and one-command installs without compiling on production servers.
AI-written summary · about
chapters (11)
- 0:00Intro
- 0:30Beginning of Postgres Ecosystem
- 3:17Past Opportunities for Postgres Ecosystem & PGXN
- 7:42The rest of the Postgres Ecosystem
- 9:59Filling the Dev & Distribution Gaps
- 14:35New Registries for Postgres Ecosystem
- 16:00State of the Postgres Ecosystem
- 17:22Future Opportunities for Postgres Ecosystem & PGXN
- 18:34Key Jobs for the Postgres Ecosystem & PGXN
- 19:54Architecture Sketch
- 21:54Product Sketch
related talks
28mBeyond Postgres: Insights about the PostgreSQL Extensibility
46mFearless Extension Development With Rust and PGRX
05mpgextensions org Your Guide to PostgreSQL Extensions Comparision on the Cloud
39mDeveloping a Postgres Extension in Rust
26mCan We Use Rust to Develop Extensions for PostgreSQL?
52mAnarchy in the Database: A Survey and Evaluation of Database Management System Extensibility
49mSupporting extensions, but really now
29mPostgres Extensions in Kubernetes