Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 9.2 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.1 → 9.2
pg_amStructural change
+ amsearcharray+ amcanreturn
pg_classStructural change
+ relallvisible
pg_procStructural change
+ protransform+ proleakproof
pg_rangeCatalog added
+ rngtypid+ rngsubtype+ rngcollation+ rngsubopc+ rngcanonical+ rngsubdiff
pg_stat_activityStructural change
+ pid+ state_change+ state+ query− procpid− current_query
pg_stat_databaseStructural change
+ temp_files+ temp_bytes+ deadlocks+ blk_read_time+ blk_write_time
pg_stat_user_functionsStructural change
~ self_time: bigint → double precision~ total_time: bigint → double precision
pg_statisticStructural change
+ stakind5+ staop5+ stanumbers5+ stavalues5
pg_statsStructural change
+ most_common_elems+ most_common_elem_freqs+ elem_count_histogram