From: Rod Taylor <pg@rbt.ca>
To: Anjan Dave <adave@vantage.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: can't handle large number of INSERT/UPDATEs
Date: Tue, 26 Oct 2004 13:48:42 -0400
Message-ID: <1098812922.8557.485.camel@home> (raw)
In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF7850985DC@vt-pe2550-001.vantage.vantage.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF7850985DC@vt-pe2550-001.vantage.vantage.com>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@rbt.ca, adave@vantage.com
Subject: Re: can't handle large number of INSERT/UPDATEs
In-Reply-To: <1098812922.8557.485.camel@home>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox