FOLLOW THE EVOLUTION

PostgreSQL 19 beta 3 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.

FROMTOInclude description updates

PostgreSQL 18 → 19

pg_available_extension_versionsStructural change

+ location

pg_available_extensionsStructural change

+ location

pg_dsm_registry_allocationsCatalog added

+ name+ type+ size

pg_foreign_data_wrapperStructural change

+ fdwconnection

pg_propgraph_elementCatalog added

+ oid+ pgepgid+ pgerelid+ pgealias+ pgekind+ pgesrcvertexid+ pgedestvertexid+ pgekey+ pgesrckey+ pgesrcref+ pgesrceqop+ pgedestkey+ pgedestref+ pgedesteqop

pg_propgraph_element_labelCatalog added

+ oid+ pgellabelid+ pgelelid

pg_propgraph_labelCatalog added

+ oid+ pglpgid+ pgllabel

pg_propgraph_label_propertyCatalog added

+ oid+ plppropid+ plpellabelid+ plpexpr

pg_propgraph_propertyCatalog added

+ oid+ pgppgid+ pgpname+ pgptypid+ pgptypmod+ pgpcollation

pg_publicationStructural change

+ puballsequences

pg_publication_relStructural change

+ prexcept

pg_publication_sequencesCatalog added

+ pubname+ schemaname+ sequencename

pg_rangeStructural change

+ rngconstruct2+ rngconstruct3+ rngmltconstruct0+ rngmltconstruct1+ rngmltconstruct2

pg_replication_slotsStructural change

+ slotsync_skip_reason

pg_stat_all_indexesStructural change

+ stats_reset

pg_stat_all_tablesStructural change

+ stats_reset

pg_stat_autovacuum_scoresCatalog added

+ relid+ schemaname+ relname+ score+ xid_score+ mxid_score+ vacuum_score+ vacuum_insert_score+ analyze_score+ do_vacuum+ do_analyze+ for_wraparound

pg_stat_database_conflictsStructural change

+ stats_reset

pg_stat_lockCatalog added

+ locktype+ waits+ wait_time+ fastpath_exceeded+ stats_reset

pg_stat_progress_analyzeStructural change

+ started_by

pg_stat_progress_basebackupStructural change

+ backup_type

pg_stat_progress_data_checksumsCatalog added

+ pid+ datid+ datname+ phase+ databases_total+ databases_done+ relations_total+ relations_done+ blocks_total+ blocks_done

pg_stat_progress_repackCatalog added

+ pid+ datid+ datname+ relid+ command+ phase+ repack_index_relid+ heap_tuples_scanned+ heap_tuples_inserted+ heap_tuples_updated+ heap_tuples_deleted+ heap_blks_total+ heap_blks_scanned+ index_rebuild_count

pg_stat_progress_vacuumStructural change

+ mode+ started_by

pg_stat_recoveryCatalog added

+ promote_triggered+ last_replayed_read_lsn+ last_replayed_end_lsn+ last_replayed_tli+ replay_end_lsn+ replay_end_tli+ recovery_last_xact_time+ current_chunk_start_time+ pause_state

pg_stat_replication_slotsStructural change

+ mem_exceeded_count+ slotsync_skip_count+ slotsync_last_skip

pg_stat_subscription_statsStructural change

+ sync_seq_error_count+ sync_table_error_count+ confl_update_deleted− sync_error_count

pg_stat_sys_indexesStructural change

+ stats_reset

pg_stat_sys_tablesStructural change

+ stats_reset

pg_stat_user_functionsStructural change

+ stats_reset

pg_stat_user_indexesStructural change

+ stats_reset