Re: [SQL] pg_multixact issues

[Dev Kumkar <devdas.kumkar@xxxxxxxxx>]

On Fri, Sep 19, 2014 at 8:07 AM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> wrote:

Can you paste the pg_controldata output please?

pg_controldata output as follows:

pg_control version number:            937
Catalog version number:               201306121
Database system identifier:           6023658189132429183
Database cluster state:               in production
pg_control last modified:             Fri Sep 19 12:09:05 2014
Latest checkpoint location:           2D3/5DB461C0
Prior checkpoint location:            2D3/5D08D0D0
Latest checkpoint's REDO location:    2D3/5D68EFE0
Latest checkpoint's REDO WAL file:    00000001000002D30000005D
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/10882952
Latest checkpoint's NextOID:          3443291
Latest checkpoint's NextMultiXactId:  3622064
Latest checkpoint's NextMultiOffset:  4294172074
Latest checkpoint's oldestXID:        1673
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint:            Fri Sep 19 12:06:35 2014
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
Current wal_level setting:            minimal
Current max_connections setting:      100
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
Data page checksum version:           0
 

 

Also, what files are there in pg_multixact/offsets/ ?

Currently there are about 56 files in  pg_multixact/offsets/.

0000  0002  0004  0006  0008  000A  000C  000E  0010  0012  0014  0016  0018  001A  001C  001E  0020  0022  0024  0026  0028  002A  002C  002E  0030  0032  0034  0036
0001  0003  0005  0007  0009  000B  000D  000F  0011  0013  0015  0017  0019  001B  001D  001F  0021  0023  0025  0027  0029  002B  002D  002F  0031  0033  0035  0037

Regards...