跳转到主要内容
FOLLOW THE EVOLUTION
PostgreSQL 14 目录变更
从一次升级开始，了解目录、字段与类型的变化。
对比任意两个版本，也可以沿着发布历史逐步探索。
比较包含 PostgreSQL 19 beta 3 快照，结果不代表最终发布结构。
PostgreSQL 13 → 14
+ attcompression↕ 字段顺序变化
+ name+ ident+ parent+ level+ total_bytes+ total_nblocks+ free_bytes+ free_chunks+ used_bytes
+ inhdetachpending
+ waitstart
+ generic_plans+ custom_plans
+ prosqlbody
+ rngmultitypid
+ two_phase
+ query_id
+ session_time+ active_time+ idle_in_transaction_time+ sessions+ sessions_abandoned+ sessions_fatal+ sessions_killed
+ pid+ datid+ datname+ relid+ command+ type+ bytes_processed+ bytes_total+ tuples_processed+ tuples_excluded
+ slot_name+ spill_txns+ spill_count+ spill_bytes+ stream_txns+ stream_count+ stream_bytes+ total_txns+ total_bytes+ stats_reset
− compression
+ wal_records+ wal_fpi+ wal_bytes+ wal_buffers_full+ wal_write+ wal_sync+ wal_write_time+ wal_sync_time+ stats_reset
+ stxexprs
+ stxdexpr
+ exprs
+ schemaname+ tablename+ statistics_schemaname+ statistics_name+ statistics_owner+ expr+ null_frac+ avg_width+ n_distinct+ most_common_vals+ most_common_freqs+ histogram_bounds+ correlation+ most_common_elems+ most_common_elem_freqs+ elem_count_histogram
+ subbinary+ substream
+ typsubscript