FOLLOW THE EVOLUTION

PostgreSQL 9.2 目录变更

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

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

PostgreSQL 9.1 → 9.2

pg_am结构变更

+ amsearcharray+ amcanreturn

+ attfdwoptions

pg_class结构变更

+ relallvisible

+ connoinherit

pg_locks结构变更

+ fastpath

pg_proc结构变更

+ protransform+ proleakproof

pg_range新增目录

+ rngtypid+ rngsubtype+ rngcollation+ rngsubopc+ rngcanonical+ rngsubdiff

+ objoid+ classoid+ provider+ label

+ pid+ state_change+ state+ query− procpid− current_query

+ checkpoint_write_time+ checkpoint_sync_time

+ temp_files+ temp_bytes+ deadlocks+ blk_read_time+ blk_write_time

+ pid− procpid

~ self_time: bigint → double precision~ total_time: bigint → double precision

~ self_time: bigint → double precision~ total_time: bigint → double precision

+ stakind5+ staop5+ stanumbers5+ stavalues5

pg_stats结构变更

+ most_common_elems+ most_common_elem_freqs+ elem_count_histogram

− spclocation

pg_type结构变更

+ typacl