Skip to content

Instantly share code, notes, and snippets.

@kuuji
Created February 28, 2018 21:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kuuji/cc73c3c193a0d58aa0e651fbd7bfec58 to your computer and use it in GitHub Desktop.
Save kuuji/cc73c3c193a0d58aa0e651fbd7bfec58 to your computer and use it in GitHub Desktop.
92_to_96

9.2

pg_control version number:            922
Catalog version number:               201204301
Database system identifier:           5890934693108502007
Database cluster state:               in production
pg_control last modified:             Wed 28 Feb 2018 08:47:58 PM UTC
Latest checkpoint location:           ABB/A607CD10
Prior checkpoint location:            ABA/D2522F30
Latest checkpoint's REDO location:    ABB/A607CD10
Latest checkpoint's TimeLineID:       8
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/128653693
Latest checkpoint's NextOID:          14300476
Latest checkpoint's NextMultiXactId:  1787864
Latest checkpoint's NextMultiOffset:  3767792
Latest checkpoint's oldestXID:        1794
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Time of latest checkpoint:            Wed 28 Feb 2018 08:47:51 PM UTC
Minimum recovery ending location:     0/0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
Current wal_level setting:            hot_standby
Current max_connections setting:      300
Current max_prepared_xacts setting:   0
Current max_locks_per_xact setting:   64
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
        oid        | relfrozenxid |    age    | txid_current
-------------------+--------------+-----------+--------------
 problematic_table |     24331740 | 104321953 |    128653693

9.6

pg_control version number:            960
Catalog version number:               201608131
Database system identifier:           6522646373901504140
Database cluster state:               in production
pg_control last modified:             Wed 28 Feb 2018 08:59:32 PM UTC
Latest checkpoint location:           B1D/EE2C0F50
Prior checkpoint location:            B1D/E9222B30
Latest checkpoint's REDO location:    B1D/EA0451E0
Latest checkpoint's REDO WAL file:    0000000100000B1D000000EA
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0:129531306
Latest checkpoint's NextOID:          14457043
Latest checkpoint's NextMultiXactId:  1802021
Latest checkpoint's NextMultiOffset:  25789
Latest checkpoint's oldestXID:        1794
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  129531306
Latest checkpoint's oldestMultiXid:   1789278
Latest checkpoint's oldestMulti's DB: 16401
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Time of latest checkpoint:            Wed 28 Feb 2018 08:55:02 PM UTC
Fake LSN counter for unlogged rels:   0/1
Minimum recovery ending location:     0/0
Min recovery ending loc's timeline:   0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
wal_level setting:                    replica
wal_log_hints setting:                off
max_connections setting:              300
max_worker_processes setting:         8
max_prepared_xacts setting:           0
max_locks_per_xact setting:           64
track_commit_timestamp setting:       off
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Size of a large-object chunk:         2048
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           0
        oid        | relfrozenxid |    age    | txid_current
-------------------+--------------+-----------+--------------
 problematic_table |     24331740 | 105200197 |    129531937
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment