Skip site navigation (1) Skip section navigation (2)

Re: can't handle large number of INSERT/UPDATEs

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Anjan Dave <adave(at)vantage(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: can't handle large number of INSERT/UPDATEs
Date: 2004-10-26 17:48:42
Message-ID: 1098812922.8557.485.camel@home (view raw or flat)
Thread:
Lists: 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?


In response to

pgsql-performance by date

Next:From: Anjan DaveDate: 2004-10-26 17:56:25
Subject: Re: can't handle large number of INSERT/UPDATEs
Previous:From: Anjan DaveDate: 2004-10-26 17:42:21
Subject: Re: can't handle large number of INSERT/UPDATEs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group