Re: [SQL] pg_multixact issues

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] pg_multixact issues
Date: 2014-09-19 07:51:16
Message-ID: CALSLE1MSyf_68KoAXSq8ayUcCwMGCDcbUBpm63TPm75SzYAdNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

On Fri, Sep 19, 2014 at 8:07 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-09-19 07:53:42 Re: [GENERAL] pg_multixact issues
Previous Message Gavin Flower 2014-09-19 07:45:25 Re: ALTER TEXT field to VARCHAR(1024)

Browse pgsql-hackers by date

  From Date Subject
Next Message Dev Kumkar 2014-09-19 07:53:42 Re: [GENERAL] pg_multixact issues
Previous Message Andres Freund 2014-09-19 07:33:57 Re: [GENERAL] pg_multixact issues

Browse pgsql-sql by date

  From Date Subject
Next Message Dev Kumkar 2014-09-19 07:53:42 Re: [GENERAL] pg_multixact issues
Previous Message Andres Freund 2014-09-19 07:33:57 Re: [GENERAL] pg_multixact issues