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@2ndQuadrant.com www.2ndQuadrant.com