FOLLOW THE EVOLUTION

PostgreSQL 17 目录变更

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

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

PostgreSQL 16 → 17

~ attstattarget: not_null: true → false↕ 字段顺序变化

+ colllocale− colliculocale

pg_database结构变更

+ dathasloginevt+ datlocale− daticulocale

+ inactive_since+ invalidation_reason+ failover+ synced

− checkpoints_timed− checkpoints_req− checkpoint_write_time− checkpoint_sync_time− buffers_checkpoint− buffers_backend− buffers_backend_fsync

+ num_timed+ num_requested+ restartpoints_timed+ restartpoints_req+ restartpoints_done+ write_time+ sync_time+ buffers_written+ stats_reset

+ tuples_skipped

+ max_dead_tuple_bytes+ dead_tuple_bytes+ num_dead_item_ids+ indexes_total+ indexes_processed− max_dead_tuples− num_dead_tuples

+ worker_type

~ stxstattarget: integer → smallint~ stxstattarget: not_null: true → false↕ 字段顺序变化

pg_stats结构变更

+ range_length_histogram+ range_empty_frac+ range_bounds_histogram

+ subfailover

+ type+ name+ description