pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes exclusive locking improve performance?
2+ messages / 2 participants
[nested] [flat]
* Does exclusive locking improve performance?
@ 2011-02-17 04:38 Jeremy Palmer <JPalmer@linz.govt.nz>
0 siblings, 1 reply; 2+ messages in thread
From: Jeremy Palmer @ 2011-02-17 04:38 UTC (permalink / raw)
To: 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.
______________________________________________________________________________________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Does exclusive locking improve performance?
@ 2011-02-17 05:18 Stephen Frost <sfrost@snowman.net>
parent: Jeremy Palmer <JPalmer@linz.govt.nz>
0 siblings, 0 replies; 2+ messages in thread
From: Stephen Frost @ 2011-02-17 05:18 UTC (permalink / raw)
To: Jeremy Palmer <JPalmer@linz.govt.nz>; +Cc: 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 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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-02-17 05:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-17 04:38 Does exclusive locking improve performance? Jeremy Palmer <JPalmer@linz.govt.nz>
2011-02-17 05:18 ` Stephen Frost <sfrost@snowman.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox