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

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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Anjan Dave" <adave(at)vantage(dot)com>, "Rod Taylor" <pg(at)rbt(dot)ca>
Subject: Re: can't handle large number of INSERT/UPDATEs
Date: 2004-10-26 18:27:02
Message-ID: 200410261127.02656.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Anjan,

> It probably is locking issue. I got a long list of locks held when we ran
> select * from pg_locks during a peak time.

Do the back-loaded tables have FKs on them?     This would be a likely cause 
of lock contention, and thus serializing inserts/updates to the tables.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Matt ClarkDate: 2004-10-26 18:28:34
Subject: Re: can't handle large number of INSERT/UPDATEs
Previous:From: Anjan DaveDate: 2004-10-26 17:56:25
Subject: Re: can't handle large number of INSERT/UPDATEs

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