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.