Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 9.1 Catalog Changes

Start from a single upgrade and see how catalogs, columns, and types changed.
Compare any two versions, or walk forward through the release history.

PostgreSQL 9.0 → 9.1
pg_amStructural change
+ amcanorderbyop+ ampredlocks+ ambuildempty− amindexnulls
pg_amopStructural change
+ amoppurpose+ amopsortfamily
pg_attrdefStructural change
~ adbin: text → pg_node_tree
pg_classStructural change
+ relpersistence− relistemp− relhasexclusion
pg_collationCatalog added
+ oid+ collname+ collnamespace+ collowner+ collencoding+ collcollate+ collctype
pg_constraintStructural change
+ convalidated~ conbin: text → pg_node_tree
pg_enumStructural change
+ enumsortorder
pg_extensionCatalog added
+ oid+ extname+ extowner+ extnamespace+ extrelocatable+ extversion+ extconfig+ extcondition
pg_indexStructural change
+ indisexclusion+ indcollation~ indexprs: text → pg_node_tree~ indpred: text → pg_node_tree
pg_procStructural change
~ proargdefaults: text → pg_node_tree
pg_rewriteStructural change
~ ev_action: text → pg_node_tree~ ev_qual: text → pg_node_tree
pg_rolesStructural change
+ rolreplication
pg_seclabelCatalog added
+ objoid+ classoid+ objsubid+ provider+ label
pg_seclabelsCatalog added
+ objoid+ classoid+ objsubid+ objtype+ objnamespace+ objname+ provider+ label
pg_stat_all_tablesStructural change
+ vacuum_count+ autovacuum_count+ analyze_count+ autoanalyze_count
pg_stat_database_conflictsCatalog added
+ datid+ datname+ confl_tablespace+ confl_lock+ confl_snapshot+ confl_bufferpin+ confl_deadlock
pg_stat_replicationCatalog added
+ 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_tablesStructural change
+ vacuum_count+ autovacuum_count+ analyze_count+ autoanalyze_count
pg_stat_user_tablesStructural change
+ vacuum_count+ autovacuum_count+ analyze_count+ autoanalyze_count
pg_stat_xact_all_tablesCatalog added
+ 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_stat_xact_sys_tablesCatalog added
+ 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_stat_xact_user_tablesCatalog added
+ 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_triggerStructural change
~ tgqual: text → pg_node_tree
pg_typeStructural change
+ typcollation~ typdefaultbin: text → pg_node_tree