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 CALSLE1N4w9LQkr=VpVMetdK6YaM3D979mkjWX+ZUVs6YjhbZFw@mail.gmail.com
Whole thread Raw
In response to Re: Transactions to create pg_multixact members and offsets  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Transactions to create pg_multixact members and offsets
List pgsql-general
On Thu, Nov 20, 2014 at 11:15 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Search for "burnmulti" in the archives, which is a contrib module to
test pg_multixact.
Thanks, got some links. Will give a try and get back.

Merely waiting does not, but more than one lock being acquired on a
tuple does cause a multixact to be created.  Try SELECT FOR SHARE on two
transactions on the same tuple.
Sure.
Also what if there are only inserts/updates which transaction have and there are no explicit select queries?

Regards...

pgsql-general by date:

Previous
From: Marcos Cano
Date:
Subject: Re: pgdump (9.2.4) not dumping all tables
Next
From: zach cruise
Date:
Subject: Re: better architecture?