Postgres Pro
Downloads
Home   >   mailing lists

Thread: Does exclusive locking improve performance?

Does exclusive locking improve performance?

From
Jeremy Palmer
Date:

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.

Re: Does exclusive locking improve performance?

From
Stephen Frost
Date:
* Jeremy Palmer (JPalmer@linz.govt.nz) wrote:
> In normal circumstances does locking a table in access exclusive mode improve insert, update and delete operation
performanceon that table. 
>
> Is MVCC disabled or somehow has less work to do?

MVCC certainly isn't disabled.  Does it have less work to do?  That's a
bit harder to say but my guess is "not so much that you'd actually be
able to notice it."..

    Thanks,

        Stephen
Attachment