Emil Briggs <[EMAIL PROTECTED]> writes:
> When I see the slowdowns there are hundreds of these with no entry for
> relation or database. Any ideas what is being locked in this case?
Per the pg_locks documentation:
Every transaction holds an exclusive lock on its transaction ID for its
entire dur
I have been trying to diagnose a performance problem we have been seeing with
a postgres application. The performance of the database server is usually
quite good but every now and then it slows to a crawl. The output of vmstat
does not show excessive CPU usage or disk IO. The output of ps does
