Extensibility lets Postgres add or customize data types, operators, access methods, and other database capabilities. It adapts the relational engine to workloads beyond traditional business data processing. section 1.1 section 7.1
Postgres provides several mechanisms for extending the core engine:
- System catalogs store metadata about database objects, allowing extensions to add data types and functions. section 7.2
- Database hooks let extensions inject logic into query planning, execution, authentication, and other events. section 7.2
- Extension logic can use SQL, PL/pgSQL, C, or Rust; compiled logic loads dynamically without recompiling the database engine. section 7.2
- Extensions must be installed on the database server and enabled for the target database before use. section 7.2
One engine, many workloads
Extensions let Postgres query JSON documents, handle time-series data, perform full-text and vector similarity searches, improve database behavior, and simplify administrative or development tasks. section 1.1 section 7.2
