Skip to content

Instantly share code, notes, and snippets.

@jberkus
Last active August 29, 2015 14:08
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 jberkus/d05db3629e8c898664c4 to your computer and use it in GitHub Desktop.
Save jberkus/d05db3629e8c898664c4 to your computer and use it in GitHub Desktop.
multixact bug?
Multixact numbers:
Latest checkpoint's NextXID: 0/1143490804
Latest checkpoint's NextOID: 371144030
Latest checkpoint's NextMultiXactId: 165978104
Latest checkpoint's NextMultiOffset: 798828566
Latest checkpoint's oldestXID: 945761490
Latest checkpoint's oldestXID's DB: 370038709
Latest checkpoint's oldestActiveXID: 1143490803
Latest checkpoint's oldestMultiXid: 123452201
Latest checkpoint's oldestMulti's DB: 370038709
Contents of pg_database:
postgres=# select datname, datminmxid from pg_database;
datname | datminmxid
-----------+------------
template1 | 162092572
template0 | 129294097
postgres | 162092587
appdev | 162092814
app2014 | 123452201
app2013 | 133670732
apptest | 162092835
Contents of pg_multixact/members:
[root@db1 members]# du -sh
1.2G
[root@db1 members]# ls -l | wc -l
4598
29B2 2A7A 2B42 2C0A 2CD2 2D9A 2E62 2F2A 2FF2 30BA 3182 324A 3312 33DA 34A2 356A 3632 36FA 37C2 388A 3952 3A1A 3AE2
29B3 2A7B 2B43 2C0B 2CD3 2D9B 2E63 2F2B 2FF3 30BB 3183 324B 3313 33DB 34A3 356B 3633 36FB 37C3 388B 3953 3A1B 3AE3
29B4 2A7C 2B44 2C0C 2CD4 2D9C 2E64 2F2C 2FF4 30BC 3184 324C 3314 33DC 34A4 356C 3634 36FC 37C4 388C 3954 3A1C 3AE4
... (many files omitted)
2A75 2B3D 2C05 2CCD 2D95 2E5D 2F25 2FED 30B5 317D 3245 330D 33D5 349D 3565 362D 36F5 37BD 3885 394D 3A15 3ADD 3BA5
2A76 2B3E 2C06 2CCE 2D96 2E5E 2F26 2FEE 30B6 317E 3246 330E 33D6 349E 3566 362E 36F6 37BE 3886 394E 3A16 3ADE
2A77 2B3F 2C07 2CCF 2D97 2E5F 2F27 2FEF 30B7 317F 3247 330F 33D7 349F 3567 362F 36F7 37BF 3887 394F 3A17 3ADF
2A78 2B40 2C08 2CD0 2D98 2E60 2F28 2FF0 30B8 3180 3248 3310 33D8 34A0 3568 3630 36F8 37C0 3888 3950 3A18 3AE0
2A79 2B41 2C09 2CD1 2D99 2E61 2F29 2FF1 30B9 3181 3249 3311 33D9 34A1 3569 3631 36F9 37C1 3889 3951 3A19 3AE1
contents of offsets/
[root@db1 offsets]# du -sh
165M .
[root@db1 offsets]# ls -l | wc -l
653
075B 0778 0795 07B2 07CF 07EC 0809 0826 0843 0860 087D 089A 08B7 08D4 08F1 090E 092B 0948 0965 0982 099F 09BC 09D9
075C 0779 0796 07B3 07D0 07ED 080A 0827 0844 0861 087E 089B 08B8 08D5 08F2 090F 092C 0949 0966 0983 09A0 09BD 09DA
075D 077A 0797 07B4 07D1 07EE 080B 0828 0845 0862 087F 089C 08B9 08D6 08F3 0910 092D 094A 0967 0984 09A1 09BE 09DB
... (many files omitted)
0775 0792 07AF 07CC 07E9 0806 0823 0840 085D 087A 0897 08B4 08D1 08EE 090B 0928 0945 0962 097F 099C 09B9 09D6
0776 0793 07B0 07CD 07EA 0807 0824 0841 085E 087B 0898 08B5 08D2 08EF 090C 0929 0946 0963 0980 099D 09BA 09D7
0777 0794 07B1 07CE 07EB 0808 0825 0842 085F 087C 0899 08B6 08D3 08F0 090D 092A 0947 0964 0981 099E 09BB 09D8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment