> 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 Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to