Performance and locks - Mailing list pgsql-general

From Jean-Luc Lachance
Subject Performance and locks
Date
Msg-id 3CDC205C.875751E9@nsd.ca
Whole thread Raw
In response to General Question About Indexes  ("shey sewani" <pakix2000@hotmail.com>)
List pgsql-general
Hi all,

Is there any kind of performance improvement that can be had by using
more restrictive locks?
Even when there is only one user?
What is the impact of locks on MVCC and/or resources.


JLL

pgsql-general by date:

Previous
From: "shey sewani"
Date:
Subject: General Question About Indexes
Next
From: "Samuel J. Sutjiono"
Date:
Subject: Why very high CPU usage