Home > mailing lists

Transactions to create pg_multixact members and offsets - Mailing list pgsql-general

From	Dev Kumkar
Subject	Transactions to create pg_multixact members and offsets
Date	November 20, 2014 20:36:54
Msg-id	CALSLE1Oyzn5ASy9i8hdtnMQ-oNqqjJhJoTBvRJbH9Yvr-WoAFg@mail.gmail.com Whole thread Raw
Responses	Re: Transactions to create pg_multixact members and offsets (Alvaro Herrera <alvherre@2ndquadrant.com>)
List	pgsql-general

Hellos,

How to manually increase pg_multixact members and offsets?

Does a transaction waiting for exclusive lock or shared lock result into entry being created in pg_multixact?

Excerpt of multixact.c:

/*-------------------------------------------------------------------------

 2  *

 3  * multixact.c

 4  * PostgreSQL multi-transaction-log manager

 5  *

 6  * The pg_multixact manager is a pg_clog-like manager that stores an array of

 7  * MultiXactMember for each MultiXactId. It is a fundamental part of the

 8  * shared-row-lock implementation. 

Regards...

From: Adrian Klaver
Date: 20 November 2014, 20:18:56
Subject: Re: pgsql_tmp consuming all inodes

From: Adrian Klaver
Date: 20 November 2014, 20:41:33
Subject: Re: better architecture?