On 2011-10-27 09:42, Gregg Jaskiewicz wrote:
What does 'select * from pg_stat_activity' say, more precisely - the "waiting" column.
Waiting is "false" for all rows. If I use pgadmin to lock at the server status all locks have been granted for hours.
Although the process does in fact use CPU this time, strace still gives a seemingly endless list of lseek calls.
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
