跳转到主要内容
FOLLOW THE EVOLUTION
PostgreSQL 19 beta 3 目录变更
从一次升级开始，了解目录、字段与类型的变化。
对比任意两个版本，也可以沿着发布历史逐步探索。
比较包含 PostgreSQL 19 beta 3 快照，结果不代表最终发布结构。
PostgreSQL 18 → 19
+ location
+ location
+ name+ type+ size
+ fdwconnection
+ oid+ pgepgid+ pgerelid+ pgealias+ pgekind+ pgesrcvertexid+ pgedestvertexid+ pgekey+ pgesrckey+ pgesrcref+ pgesrceqop+ pgedestkey+ pgedestref+ pgedesteqop
+ oid+ pgellabelid+ pgelelid
+ oid+ pglpgid+ pgllabel
+ oid+ plppropid+ plpellabelid+ plpexpr
+ oid+ pgppgid+ pgpname+ pgptypid+ pgptypmod+ pgpcollation
+ puballsequences
+ prexcept
+ pubname+ schemaname+ sequencename
+ rngconstruct2+ rngconstruct3+ rngmltconstruct0+ rngmltconstruct1+ rngmltconstruct2
+ slotsync_skip_reason
+ stats_reset
+ stats_reset
+ relid+ schemaname+ relname+ score+ xid_score+ mxid_score+ vacuum_score+ vacuum_insert_score+ analyze_score+ do_vacuum+ do_analyze+ for_wraparound
+ stats_reset
+ locktype+ waits+ wait_time+ fastpath_exceeded+ stats_reset
+ started_by
+ backup_type
+ pid+ datid+ datname+ phase+ databases_total+ databases_done+ relations_total+ relations_done+ blocks_total+ blocks_done
+ pid+ datid+ datname+ relid+ command+ phase+ repack_index_relid+ heap_tuples_scanned+ heap_tuples_inserted+ heap_tuples_updated+ heap_tuples_deleted+ heap_blks_total+ heap_blks_scanned+ index_rebuild_count
+ mode+ started_by
+ promote_triggered+ last_replayed_read_lsn+ last_replayed_end_lsn+ last_replayed_tli+ replay_end_lsn+ replay_end_tli+ recovery_last_xact_time+ current_chunk_start_time+ pause_state
+ mem_exceeded_count+ slotsync_skip_count+ slotsync_last_skip
+ sync_seq_error_count+ sync_table_error_count+ confl_update_deleted− sync_error_count
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ wal_fpi_bytes
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ stats_reset
+ tableid+ attnum
+ tableid+ statistics_id
+ tableid+ statistics_id+ range_length_histogram+ range_empty_frac+ range_bounds_histogram
+ subretaindeadtuples+ submaxretention+ subretentionactive+ subserver+ subwalrcvtimeout~ subconninfo: not_null: true → false