Re: can't handle large number of INSERT/UPDATEs - Mailing list pgsql-performance

From Rod Taylor
Subject Re: can't handle large number of INSERT/UPDATEs
Date
Msg-id 1098812922.8557.485.camel@home
Whole thread Raw
In response to Re: can't handle large number of INSERT/UPDATEs  ("Anjan Dave" <adave@vantage.com>)
List pgsql-performance
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?


pgsql-performance by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs
Next
From: "Anjan Dave"
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs