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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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