Guys,
> Well, inserts create some locks - perhaps that's the problem...
>
> Otherwise, check the pg_locks view to see if you can figure it out.
FWIW, I've had this happen a couple of times, too. Unfortunately, it's
happend in the middle of the day so that I had to cancel the processes and
get the system back to normal in too much of a hurry to consider documenting
it.
--
Josh Berkus
Aglio Database Solutions
San Francisco