What changed?

System Catalogs · PostgreSQL 16 → 17

2 added · 0 removed · 11 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

--- 16
+++ 17
@@ -18,8 +18,8 @@
 attisdropped  bool
 attislocal  bool
 attinhcount  int2
+attcollation  oid
 attstattarget  int2
-attcollation  oid
 attacl  aclitem[]
 attoptions  text[]
 attfdwoptions  text[]

changedpg_collation

--- 16
+++ 17
@@ -7,6 +7,6 @@
 collencoding  int4
 collcollate  text
 collctype  text
-colliculocale  text
+colllocale  text
 collicurules  text
 collversion  text

changedpg_database

--- 16
+++ 17
@@ -5,13 +5,14 @@
 datlocprovider  char
 datistemplate  bool
 datallowconn  bool
+dathasloginevt  bool
 datconnlimit  int4
 datfrozenxid  xid
 datminmxid  xid
 dattablespace  oid
 datcollate  text
 datctype  text
-daticulocale  text
+datlocale  text
 daticurules  text
 datcollversion  text
 datacl  aclitem[]

changedpg_replication_slots

--- 16
+++ 17
@@ -13,4 +13,8 @@
 wal_status  text
 safe_wal_size  int8
 two_phase  bool
+inactive_since  timestamptz
 conflicting  bool
+invalidation_reason  text
+failover  bool
+synced  bool

changedpg_stat_bgwriter

--- 16
+++ 17
@@ -1,11 +1,4 @@
-checkpoints_timed  bigint
-checkpoints_req  bigint
-checkpoint_write_time  double precision
-checkpoint_sync_time  double precision
-buffers_checkpoint  bigint
 buffers_clean  bigint
 maxwritten_clean  bigint
-buffers_backend  bigint
-buffers_backend_fsync  bigint
 buffers_alloc  bigint
 stats_reset  timestamp with time zone

addedpg_stat_checkpointer

--- 16
+++ 17
@@ -0,0 +1,9 @@
+num_timed  bigint
+num_requested  bigint
+restartpoints_timed  bigint
+restartpoints_req  bigint
+restartpoints_done  bigint
+write_time  double precision
+sync_time  double precision
+buffers_written  bigint
+stats_reset  timestamp with time zone

changedpg_stat_progress_copy

--- 16
+++ 17
@@ -8,3 +8,4 @@
 bytes_total  bigint
 tuples_processed  bigint
 tuples_excluded  bigint
+tuples_skipped  bigint

changedpg_stat_progress_vacuum

--- 16
+++ 17
@@ -7,5 +7,8 @@
 heap_blks_scanned  bigint
 heap_blks_vacuumed  bigint
 index_vacuum_count  bigint
-max_dead_tuples  bigint
-num_dead_tuples  bigint
+max_dead_tuple_bytes  bigint
+dead_tuple_bytes  bigint
+num_dead_item_ids  bigint
+indexes_total  bigint
+indexes_processed  bigint

changedpg_stat_subscription

--- 16
+++ 17
@@ -1,5 +1,6 @@
 subid  oid
 subname  name
+worker_type  text
 pid  integer
 leader_pid  integer
 relid  oid

changedpg_statistic_ext

--- 16
+++ 17
@@ -3,7 +3,7 @@
 stxname  name
 stxnamespace  oid
 stxowner  oid
-stxstattarget  int4
 stxkeys  int2vector
+stxstattarget  int2
 stxkind  char[]
 stxexprs  pg_node_tree

changedpg_stats

--- 16
+++ 17
@@ -12,3 +12,6 @@
 most_common_elems  anyarray
 most_common_elem_freqs  float4[]
 elem_count_histogram  float4[]
+range_length_histogram  anyarray
+range_empty_frac  float4
+range_bounds_histogram  anyarray

changedpg_subscription

--- 16
+++ 17
@@ -10,6 +10,7 @@
 subdisableonerr  bool
 subpasswordrequired  bool
 subrunasowner  bool
+subfailover  bool
 subconninfo  text
 subslotname  name
 subsynccommit  text

addedpg_wait_events

--- 16
+++ 17
@@ -0,0 +1,3 @@
+type  text
+name  text
+description  text