Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 9.6 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 9.5 → 9.6
pg_aggregateStructural change
+ aggcombinefn+ aggserialfn+ aggdeserialfn
pg_amStructural change
+ amhandler+ amtype− amstrategies− amsupport− amcanorder− amcanorderbyop− amcanbackward− amcanunique− amcanmulticol− amoptionalkey− amsearcharray− amsearchnulls− amstorage− amclusterable− ampredlocks− amkeytype− aminsert− ambeginscan− amgettuple− amgetbitmap− amrescan− amendscan− ammarkpos− amrestrpos− ambuild− ambuildempty− ambulkdelete− amvacuumcleanup− amcanreturn− amcostestimate− amoptions
pg_init_privsCatalog added
+ objoid+ classoid+ objsubid+ privtype+ initprivs
pg_procStructural change
+ proparallel
pg_stat_progress_vacuumCatalog added
+ pid+ datid+ datname+ relid+ phase+ heap_blks_total+ heap_blks_scanned+ heap_blks_vacuumed+ index_vacuum_count+ max_dead_tuples+ num_dead_tuples
pg_stat_wal_receiverCatalog added
+ pid+ status+ receive_start_lsn+ receive_start_tli+ received_lsn+ received_tli+ last_msg_send_time+ last_msg_receipt_time+ latest_end_lsn+ latest_end_time+ slot_name+ conninfo