Does exclusive locking improve performance?

From: Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Does exclusive locking improve performance?
Date: 2011-02-17 04:38:34
Message-ID: 666FB8D75E95AE42965A0E76A5E5337E06D966C6FD@prdlsmmsg01.ad.linz.govt.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)linz(dot)govt(dot)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.
______________________________________________________________________________________________________

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Frost 2011-02-17 05:18:35 Re: Does exclusive locking improve performance?
Previous Message Greg Smith 2011-02-16 22:02:40 Re: Estimating hot data size