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? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster