Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 15 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 14 → 15
pg_collationStructural change
+ colliculocale~ collcollate: name → text~ collctype: name → text~ collcollate: not_null: true → false~ collctype: not_null: true → false
pg_databaseStructural change
+ datlocprovider+ daticulocale+ datcollversion− datlastsysoid~ datcollate: name → text~ datctype: name → text↕ Column order changed
pg_indexStructural change
+ indnullsnotdistinct
+ stats_reset+ prefetch+ hit+ skip_init+ skip_new+ skip_fpw+ skip_rep+ wal_distance+ block_distance+ io_depth
pg_subscriptionStructural change
+ subskiplsn+ subtwophasestate+ subdisableonerr