Bob Dusek wrote:
How do I learn more about the actual lock contention in my db?
There's a page with a sample query and links to more info at http://wiki.postgresql.org/wiki/Lock_Monitoring
One other little thing: when you're running "top", try using "top -c" instead. That should show you exactly what all the postmaster backends are actually doing, which is really handy to sort out issues in this area.
-- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance