What changed?

System Catalogs · PostgreSQL 9.3 → 9.4

Historical documentation for a PostgreSQL version that is no longer supported.

2 added · 0 removed · 9 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

--- 9.3
+++ 9.4
@@ -1,6 +1,17 @@
 aggfnoid  regproc
+aggkind  char
+aggnumdirectargs  int2
 aggtransfn  regproc
 aggfinalfn  regproc
+aggmtransfn  regproc
+aggminvtransfn  regproc
+aggmfinalfn  regproc
+aggfinalextra  bool
+aggmfinalextra  bool
 aggsortop  oid
 aggtranstype  oid
+aggtransspace  int4
+aggmtranstype  oid
+aggmtransspace  int4
 agginitval  text
+aggminitval  text

changedpg_class

--- 9.3
+++ 9.4
@@ -11,7 +11,6 @@
 reltuples  float4
 relallvisible  int4
 reltoastrelid  oid
-reltoastidxid  oid
 relhasindex  bool
 relisshared  bool
 relpersistence  char
@@ -24,6 +23,7 @@
 relhastriggers  bool
 relhassubclass  bool
 relispopulated  bool
+relreplident  char
 relfrozenxid  xid
 relminmxid  xid
 relacl  aclitem[]

changedpg_index

--- 9.3
+++ 9.4
@@ -10,6 +10,7 @@
 indcheckxmin  bool
 indisready  bool
 indislive  bool
+indisreplident  bool
 indkey  int2vector
 indcollation  oidvector
 indclass  oidvector

addedpg_replication_slots

--- 9.3
+++ 9.4
@@ -0,0 +1,9 @@
+slot_name  name
+plugin  name
+slot_type  text
+datoid  oid
+database  text
+active  boolean
+xmin  xid
+catalog_xmin  xid
+restart_lsn  pg_lsn

changedpg_rewrite

--- 9.3
+++ 9.4
@@ -1,7 +1,6 @@
 oid  oid
 rulename  name
 ev_class  oid
-ev_attr  int2
 ev_type  char
 ev_enabled  char
 is_instead  bool

changedpg_stat_activity

--- 9.3
+++ 9.4
@@ -13,4 +13,6 @@
 state_change  timestamp with time zone
 waiting  boolean
 state  text
+backend_xid  xid
+backend_xmin  xid
 query  text

changedpg_stat_all_tables

--- 9.3
+++ 9.4
@@ -11,6 +11,7 @@
 n_tup_hot_upd  bigint
 n_live_tup  bigint
 n_dead_tup  bigint
+n_mod_since_analyze  bigint
 last_vacuum  timestamp with time zone
 last_autovacuum  timestamp with time zone
 last_analyze  timestamp with time zone

addedpg_stat_archiver

--- 9.3
+++ 9.4
@@ -0,0 +1,7 @@
+archived_count  bigint
+last_archived_wal  text
+last_archived_time  timestamp with time zone
+failed_count  bigint
+last_failed_wal  text
+last_failed_time  timestamp with time zone
+stats_reset  timestamp with time zone

changedpg_stat_replication

--- 9.3
+++ 9.4
@@ -6,10 +6,11 @@
 client_hostname  text
 client_port  integer
 backend_start  timestamp with time zone
+backend_xmin  xid
 state  text
-sent_location  text
-write_location  text
-flush_location  text
-replay_location  text
+sent_location  pg_lsn
+write_location  pg_lsn
+flush_location  pg_lsn
+replay_location  pg_lsn
 sync_priority  integer
 sync_state  text

changedpg_stat_sys_tables

--- 9.3
+++ 9.4
@@ -11,6 +11,7 @@
 n_tup_hot_upd  bigint
 n_live_tup  bigint
 n_dead_tup  bigint
+n_mod_since_analyze  bigint
 last_vacuum  timestamp with time zone
 last_autovacuum  timestamp with time zone
 last_analyze  timestamp with time zone

changedpg_stat_user_tables

--- 9.3
+++ 9.4
@@ -11,6 +11,7 @@
 n_tup_hot_upd  bigint
 n_live_tup  bigint
 n_dead_tup  bigint
+n_mod_since_analyze  bigint
 last_vacuum  timestamp with time zone
 last_autovacuum  timestamp with time zone
 last_analyze  timestamp with time zone