Re: Transactions to create pg_multixact members and offsets

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transactions to create pg_multixact members and offsets
Date: 2014-11-25 21:02:09
Message-ID: CALSLE1OgrKUeU-ezSnRfXcRXKKztgjCRUjEV2prfSgFQWEh3Ww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 21, 2014 at 1:14 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

>
> If there are foreign keys on the tables, the system internally runs some
> SELECT FOR KEY SHARE queries on the referenced tables (the ones
> containing the primary or unique keys). You can get some multixacts
> that way too.
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

Thanks !

If I recollect correct, then is the cleanup of pg_multixact/members fixed
in 9.3.5 release?

Regards...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-11-25 21:07:51 Lock Management: Waiting on locks
Previous Message Bill Moran 2014-11-25 21:01:05 Re: SQL functions and triggers?