Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Jeff Dik <jeffdik(at)finecode(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction
Date: 2015-09-23 15:26:06
Message-ID: 20150923152605.GS295765@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Dik wrote:

> Is there any way to inspect a multixact via psql to see what transaction ID
> values it has? I wasn't able to find anything while searching for an hour
> or so.

There's the function pg_get_multixact_members(xid),

=# select * from pg_get_multixact_members('1');

xid | mode
------+--------
5401 | keysh
5402 | forupd
...

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ramesh T 2015-09-23 15:46:33 pgcrypto
Previous Message Juan Pablo L. 2015-09-23 14:50:29 Re: numeric data type