Date: 2025-05-14
Time: 11:30–12:20
Room: Breakout Room 1
Level: Advanced
Extensions are one PostgreSQL's most powerful features, yet they are fraught with peril.
Extension versions that don't match the binaries, incompatibility between extensions in hooks, the database vs. cluster mismatch, search_path overloading and other privilege escalation attacks, multi-PG-version challenges, non-deterministic extension dependency upgrades, the impossibility of creating an extension-level background worker, and many other problems underpin extension development.
This talk will go through the structural problems that PostgreSQL extension developers face if they wish to build reliable, sustainable extensions, deriving from a decade of working on extensions such as Citus, pg_cron, and many others.