跳转到主要内容
FOLLOW THE EVOLUTION
PostgreSQL 18 目录变更
从一次升级开始，了解目录、字段与类型的变化。
对比任意两个版本，也可以沿着发布历史逐步探索。
比较包含 PostgreSQL 19 beta 3 快照，结果不代表最终发布结构。
PostgreSQL 17 → 18
+ pid+ io_id+ io_generation+ state+ operation+ off+ length+ target+ handle_data_len+ raw_result+ result+ target_desc+ f_sync+ f_localmem+ f_buffered
− attcacheoff
+ type+ path− parent
+ relallfrozen
+ conenforced+ conperiod
+ pubgencols
+ two_phase_at
+ name+ numa_node+ size
+ total_vacuum_time+ total_autovacuum_time+ total_analyze_time+ total_autoanalyze_time
+ num_done+ slru_written
+ parallel_workers_to_launch+ parallel_workers_launched
+ read_bytes+ write_bytes+ extend_bytes− op_bytes
+ delay_time
+ delay_time
+ confl_insert_exists+ confl_update_origin_differs+ confl_update_exists+ confl_update_missing+ confl_delete_origin_differs+ confl_delete_missing+ confl_multiple_unique_conflicts
+ total_vacuum_time+ total_autovacuum_time+ total_analyze_time+ total_autoanalyze_time
+ total_vacuum_time+ total_autovacuum_time+ total_analyze_time+ total_autoanalyze_time
− wal_write− wal_sync− wal_write_time− wal_sync_time