Postgres Pro
Downloads
Home   >   mailing lists

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

From Dev Kumkar
Subject Re: Transactions to create pg_multixact members and offsets
Date
Msg-id CALSLE1OgrKUeU-ezSnRfXcRXKKztgjCRUjEV2prfSgFQWEh3Ww@mail.gmail.com
Whole thread Raw
In response to Re: Transactions to create pg_multixact members and offsets  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view
On Fri, Nov 21, 2014 at 1:14 AM, Alvaro Herrera <alvherre@2ndquadrant.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...

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: SQL functions and triggers?
Next
From: Bill Moran
Date:
Subject: Re: SQL functions and triggers?