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