Postgres Pro
Downloads
Home   >   mailing lists

Re: Prepared transaction releasing locks before deregistering its GID - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Prepared transaction releasing locks before deregistering its GID
Date
Msg-id 20190225053015.GC30864@paquier.xyz
Whole thread Raw
In response to Re: Prepared transaction releasing locks before deregistering its GID  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view 
On Mon, Feb 25, 2019 at 02:28:23PM +0900, Michael Paquier wrote:
> Done.  I have spent some time today looking at the performance of the
> patch, designing a worst-case scenario to see how much bloat this adds
> in COMMIT PREPARED by running across many sessions 2PC transactions
> taking SHARE locks across many tables, as done in the script attached.

And of course I forgot the script, which is now attached.
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Prepared transaction releasing locks before deregistering its GID
Next
From: David Rowley
Date:
Subject: Should we increase the default vacuum_cost_limit?