Re: PostgreSQL 9.0.4 blocking in lseek? - Mailing list pgsql-performance

From Sören Meyer-Eppler
Subject Re: PostgreSQL 9.0.4 blocking in lseek?
Date
Msg-id 4EA948A2.4030602@google.com
Whole thread Raw
In response to Re: PostgreSQL 9.0.4 blocking in lseek?  (Gregg Jaskiewicz <gryzman@gmail.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Gregg Jaskiewicz
Date:
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?
Next
From: Claudio Freire
Date:
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?