Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 16 Catalog Changes

Start from a single upgrade and see how catalogs, columns, and types changed.
Compare any two versions, or walk forward through the release history.

PostgreSQL 15 → 16
pg_attributeStructural change
~ attinhcount: integer → smallint~ attndims: integer → smallint~ attstattarget: integer → smallint↕ Column order changed
pg_constraintStructural change
~ coninhcount: integer → smallint
pg_stat_ioCatalog added
+ backend_type+ object+ context+ reads+ read_time+ writes+ write_time+ writebacks+ writeback_time+ extends+ extend_time+ op_bytes+ hits+ evictions+ reuses+ fsyncs+ fsync_time+ stats_reset
pg_subscriptionStructural change
+ subpasswordrequired+ subrunasowner+ suborigin~ substream: boolean → "char"