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-20 18:56:30
Message-ID: CALSLE1N4w9LQkr=VpVMetdK6YaM3D979mkjWX+ZUVs6YjhbZFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 20, 2014 at 11:15 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zach cruise 2014-11-20 19:02:49 Re: better architecture?
Previous Message Marcos Cano 2014-11-20 18:52:23 Re: pgdump (9.2.4) not dumping all tables