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

From Stephen Frost
Subject Re: Does exclusive locking improve performance?
Date
Msg-id 20110217051835.GU4116@tamriel.snowman.net
Whole thread Raw
In response to Does exclusive locking improve performance?  (Jeremy Palmer <JPalmer@linz.govt.nz>)
List pgsql-performance
* 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

pgsql-performance by date:

Previous
From: Jeremy Palmer
Date:
Subject: Does exclusive locking improve performance?
Next
From: "Pierre C"
Date:
Subject: Re: high user cpu, massive SELECTs, no io waiting problem