跳转到主要内容

FOLLOW THE EVOLUTION

PostgreSQL 9.1 目录变更

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

PostgreSQL 9.0 → 9.1
pg_am结构变更
+ amcanorderbyop+ ampredlocks+ ambuildempty− amindexnulls
pg_amop结构变更
+ amoppurpose+ amopsortfamily
pg_attrdef结构变更
~ adbin: text → pg_node_tree
pg_class结构变更
+ relpersistence− relistemp− relhasexclusion
pg_collation新增目录
+ oid+ collname+ collnamespace+ collowner+ collencoding+ collcollate+ collctype
pg_constraint结构变更
+ convalidated~ conbin: text → pg_node_tree
pg_extension新增目录
+ oid+ extname+ extowner+ extnamespace+ extrelocatable+ extversion+ extconfig+ extcondition
pg_index结构变更
+ indisexclusion+ indcollation~ indexprs: text → pg_node_tree~ indpred: text → pg_node_tree
pg_proc结构变更
~ proargdefaults: text → pg_node_tree
pg_rewrite结构变更
~ ev_action: text → pg_node_tree~ ev_qual: text → pg_node_tree
pg_seclabel新增目录
+ objoid+ classoid+ objsubid+ provider+ label
pg_seclabels新增目录
+ objoid+ classoid+ objsubid+ objtype+ objnamespace+ objname+ provider+ label
pg_stat_all_tables结构变更
+ vacuum_count+ autovacuum_count+ analyze_count+ autoanalyze_count
+ datid+ datname+ confl_tablespace+ confl_lock+ confl_snapshot+ confl_bufferpin+ confl_deadlock
+ procpid+ usesysid+ usename+ application_name+ client_addr+ client_hostname+ client_port+ backend_start+ state+ sent_location+ write_location+ flush_location+ replay_location+ sync_priority+ sync_state
pg_stat_sys_tables结构变更
+ vacuum_count+ autovacuum_count+ analyze_count+ autoanalyze_count
+ vacuum_count+ autovacuum_count+ analyze_count+ autoanalyze_count
+ relid+ schemaname+ relname+ seq_scan+ seq_tup_read+ idx_scan+ idx_tup_fetch+ n_tup_ins+ n_tup_upd+ n_tup_del+ n_tup_hot_upd
+ relid+ schemaname+ relname+ seq_scan+ seq_tup_read+ idx_scan+ idx_tup_fetch+ n_tup_ins+ n_tup_upd+ n_tup_del+ n_tup_hot_upd
+ relid+ schemaname+ relname+ seq_scan+ seq_tup_read+ idx_scan+ idx_tup_fetch+ n_tup_ins+ n_tup_upd+ n_tup_del+ n_tup_hot_upd
pg_trigger结构变更
~ tgqual: text → pg_node_tree
pg_type结构变更
+ typcollation~ typdefaultbin: text → pg_node_tree