FOLLOW THE EVOLUTION

每个版本，都有迹可循。

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

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

PostgreSQL 17 → 18

pg_aios新增目录

+ pid+ io_id+ io_generation+ state+ operation+ off+ length+ target+ handle_data_len+ raw_result+ result+ target_desc+ f_sync+ f_localmem+ f_buffered

pg_attribute结构变更

− attcacheoff

pg_backend_memory_contexts结构变更

+ type+ path− parent

pg_class结构变更

+ relallfrozen

pg_constraint结构变更

+ conenforced+ conperiod

pg_publication结构变更

+ pubgencols

pg_replication_slots结构变更

+ two_phase_at

pg_shmem_allocations_numa新增目录

+ name+ numa_node+ size

pg_stat_all_tables结构变更

+ total_vacuum_time+ total_autovacuum_time+ total_analyze_time+ total_autoanalyze_time

pg_stat_checkpointer结构变更

+ num_done+ slru_written

pg_stat_database结构变更

+ parallel_workers_to_launch+ parallel_workers_launched

pg_stat_io结构变更

+ read_bytes+ write_bytes+ extend_bytes− op_bytes

pg_stat_progress_analyze结构变更

+ delay_time

pg_stat_progress_vacuum结构变更

+ delay_time

pg_stat_subscription_stats结构变更

+ confl_insert_exists+ confl_update_origin_differs+ confl_update_exists+ confl_update_missing+ confl_delete_origin_differs+ confl_delete_missing+ confl_multiple_unique_conflicts

pg_stat_sys_tables结构变更

+ total_vacuum_time+ total_autovacuum_time+ total_analyze_time+ total_autoanalyze_time

pg_stat_user_tables结构变更

+ total_vacuum_time+ total_autovacuum_time+ total_analyze_time+ total_autoanalyze_time

pg_stat_wal结构变更

− wal_write− wal_sync− wal_write_time− wal_sync_time