How deeply does Just Use Postgres! cover database extension?

Explains catalogs, hooks, dynamic loading, installation, and inspection, but only surveys extension categories and omits detailed deployment guidance.

Database extension

As explained in Just Use Postgres!

A Postgres extension is an installable package that adds data types, functions, operators, indexes, or other capabilities to a PostgreSQL database system.

A Postgres extension is an installable package that adds data types, functions, operators, indexes, or other capabilities to PostgreSQL. Its ecosystem lets Postgres support workloads such as JSON, time-series, full-text, vector, geospatial, messaging, and analytical processing beyond the core engine. section 1.1 section 7.3

Postgres supports extensions through several integration mechanisms:

Catalog-driven operations let extensions add database objects such as data types and functions through system catalogs. section 7.2
Database hooks let extensions inject logic into events such as query planning, execution, and authentication. section 7.2
Extension logic can use SQL, PL/pgSQL, C, or Rust; compiled implementations load shared libraries at runtime without recompiling Postgres. section 7.2
Extensions must be installed on the database server and enabled for an individual database before use. section 7.2

Inspect extensions available to a database

Query pg_available_extensions to inspect names, descriptions, default versions, and installed versions. A blank installed_version means the extension is available on the server but not enabled in the current database. Filtering with installed_version IS NOT NULL lists enabled extensions; a sample database reports only plpgsql installed. section 7.2.1

SELECT count(*) FROM pg_available_extensions;

 count
-------
    45
(1 row)

Use the supplied result to verify how many extensions are available on a Postgres server; the example reports 45. section 7.2.1

How Just Use Postgres! covers it

liveBook manning.com

Read Just Use Postgres! on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

DuckDB in ActionA database extension is an installable software component that adds capabilities to a database system.

Compare how 2 books explain database extension →

Related concepts

pg_statvizincludes · pg_statviz is a PostgreSQL extension for capturing, storing, analyzing, and visualizing database statistics over time.
auto_explainincludes · auto_explain is a PostgreSQL extension that automatically logs execution plans for queries meeting configured conditions.
pgvectorincludes · pgvector is a PostgreSQL extension that adds vector data types, similarity operations, and indexes for storing and searching vector data.
TimescaleDBincludes · TimescaleDB is a PostgreSQL extension optimized for storing and querying time-series data.

This explainer was generated by Manning's knowledge graph from the text of Just Use Postgres!. The section links point to the parts of the book it draws on.