On Tue, 2004-10-26 at 13:42, Anjan Dave wrote:
> It probably is locking issue. I got a long list of locks held when we ran select * from pg_locks during a peak time.
>
> relation | database | transaction | pid | mode | granted
> ----------+----------+-------------+-------+------------------+---------
> 17239 | 17142 | | 3856 | AccessShareLock | t
How many have granted = false?
> Vmstat would show a lot of disk IO at the same time.
>
> Is this pointing towards a disk IO issue?
Not necessarily. Is your IO reaching the limit or is it just heavy?
