[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Does exclusive locking improve performance?
From:       Stephen Frost <sfrost () snowman ! net>
Date:       2011-02-17 5:18:35
Message-ID: 20110217051835.GU4116 () tamriel ! snowman ! net
[Download RAW message or body]


* Jeremy Palmer (JPalmer@linz.govt.nz) wrote:
> 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?

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


["signature.asc" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]