Does exclusive locking improve performance? - Mailing list pgsql-performance

From Jeremy Palmer
Subject Does exclusive locking improve performance?
Date
Msg-id 666FB8D75E95AE42965A0E76A5E5337E06D966C6FD@prdlsmmsg01.ad.linz.govt.nz
Whole thread Raw
Responses Re: Does exclusive locking improve performance?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-performance

In normal circumstances does locking a table in access exclusive mode improve insert, update and delete operation performance on that table.

 

Is MVCC disabled or somehow has less work to do?

 

Cheers

Jeremy


This message contains information, which is confidential and may be subject to legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info@linz.govt.nz ) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.
 
Thank you.

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Estimating hot data size
Next
From: Stephen Frost
Date:
Subject: Re: Does exclusive locking improve performance?