跳转到主要内容

FOLLOW THE EVOLUTION

PostgreSQL 12 目录变更

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

PostgreSQL 11 → 12
pg_am结构变更
~ oid: 隐式列 → 常规列
pg_amop结构变更
~ oid: 隐式列 → 常规列
pg_amproc结构变更
~ oid: 隐式列 → 常规列
pg_attrdef结构变更
− adsrc~ adbin: not_null: false → true~ oid: 隐式列 → 常规列
pg_authid结构变更
~ oid: 隐式列 → 常规列
pg_cast结构变更
~ oid: 隐式列 → 常规列
pg_class结构变更
− relhasoids~ oid: 隐式列 → 常规列
pg_collation结构变更
+ collisdeterministic~ oid: 隐式列 → 常规列
pg_constraint结构变更
− consrc~ oid: 隐式列 → 常规列
pg_default_acl结构变更
~ defaclacl: not_null: false → true~ oid: 隐式列 → 常规列
pg_enum结构变更
~ oid: 隐式列 → 常规列
pg_opclass结构变更
~ oid: 隐式列 → 常规列
pg_policy结构变更
~ oid: 隐式列 → 常规列~ polroles: not_null: false → true
pg_proc结构变更
+ prosupport− protransform~ oid: 隐式列 → 常规列
pg_rewrite结构变更
~ ev_action: not_null: false → true~ ev_qual: not_null: false → true~ oid: 隐式列 → 常规列
pg_shadow结构变更
~ valuntil: abstime → timestamp with time zone
pg_stat_gssapi新增目录
+ pid+ gss_authenticated+ principal+ encrypted
pg_stat_progress_cluster新增目录
+ pid+ datid+ datname+ relid+ command+ phase+ cluster_index_relid+ heap_tuples_scanned+ heap_tuples_written+ heap_blks_total+ heap_blks_scanned+ index_rebuild_count
pg_stat_progress_create_index新增目录
+ pid+ datid+ datname+ relid+ index_relid+ command+ phase+ lockers_total+ lockers_done+ current_locker_pid+ blocks_total+ blocks_done+ tuples_total+ tuples_done+ partitions_total+ partitions_done
pg_stat_ssl结构变更
+ client_dn+ client_serial+ issuer_dn− clientdn
pg_statistic结构变更
+ stacoll1+ stacoll2+ stacoll3+ stacoll4+ stacoll5
pg_statistic_ext结构变更
− stxndistinct− stxdependencies~ oid: 隐式列 → 常规列
pg_stats_ext新增目录
+ schemaname+ tablename+ statistics_schemaname+ statistics_name+ statistics_owner+ attnames+ kinds+ n_distinct+ dependencies+ most_common_vals+ most_common_val_nulls+ most_common_freqs+ most_common_base_freqs
pg_trigger结构变更
~ oid: 隐式列 → 常规列
pg_ts_dict结构变更
~ oid: 隐式列 → 常规列
pg_type结构变更
~ oid: 隐式列 → 常规列
pg_user结构变更
~ valuntil: abstime → timestamp with time zone