FOLLOW THE EVOLUTION

PostgreSQL 16 目录变更

从一次升级开始，了解目录、字段与类型的变化。
对比任意两个版本，也可以沿着发布历史逐步探索。

起始版本 / FROM目标版本 / TO包含描述更新

PostgreSQL 15 → 16

pg_attribute结构变更

~ attinhcount: integer → smallint~ attndims: integer → smallint~ attstattarget: integer → smallint↕ 字段顺序变化

pg_auth_members结构变更

+ oid+ inherit_option+ set_option

pg_collation结构变更

+ collicurules

pg_constraint结构变更

~ coninhcount: integer → smallint

pg_database结构变更

+ daticurules

pg_hba_file_rules结构变更

+ rule_number+ file_name

pg_ident_file_mappings结构变更

+ map_number+ file_name

pg_prepared_statements结构变更

+ result_types

pg_replication_slots结构变更

+ conflicting

pg_stat_all_indexes结构变更

+ last_idx_scan

pg_stat_all_tables结构变更

+ last_seq_scan+ last_idx_scan+ n_tup_newpage_upd

pg_stat_database_conflicts结构变更

+ confl_active_logicalslot

pg_stat_gssapi结构变更

+ credentials_delegated

pg_stat_io新增目录

+ 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_stat_subscription结构变更

+ leader_pid

pg_stat_sys_indexes结构变更

+ last_idx_scan

pg_stat_sys_tables结构变更

+ last_seq_scan+ last_idx_scan+ n_tup_newpage_upd

pg_stat_user_indexes结构变更

+ last_idx_scan

pg_stat_user_tables结构变更

+ last_seq_scan+ last_idx_scan+ n_tup_newpage_upd

pg_stat_xact_all_tables结构变更

+ n_tup_newpage_upd

pg_stat_xact_sys_tables结构变更

+ n_tup_newpage_upd

pg_stat_xact_user_tables结构变更

+ n_tup_newpage_upd

pg_subscription结构变更

+ subpasswordrequired+ subrunasowner+ suborigin~ substream: boolean → "char"