跳转到主要内容

FOLLOW THE EVOLUTION

PostgreSQL 9.6 目录变更

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

PostgreSQL 9.5 → 9.6
pg_aggregate结构变更
+ aggcombinefn+ aggserialfn+ aggdeserialfn
pg_am结构变更
+ amhandler+ amtype− amstrategies− amsupport− amcanorder− amcanorderbyop− amcanbackward− amcanunique− amcanmulticol− amoptionalkey− amsearcharray− amsearchnulls− amstorage− amclusterable− ampredlocks− amkeytype− aminsert− ambeginscan− amgettuple− amgetbitmap− amrescan− amendscan− ammarkpos− amrestrpos− ambuild− ambuildempty− ambulkdelete− amvacuumcleanup− amcanreturn− amcostestimate− amoptions
pg_init_privs新增目录
+ objoid+ classoid+ objsubid+ privtype+ initprivs
+ pid+ datid+ datname+ relid+ phase+ heap_blks_total+ heap_blks_scanned+ heap_blks_vacuumed+ index_vacuum_count+ max_dead_tuples+ num_dead_tuples
+ pid+ status+ receive_start_lsn+ receive_start_tli+ received_lsn+ received_tli+ last_msg_send_time+ last_msg_receipt_time+ latest_end_lsn+ latest_end_time+ slot_name+ conninfo