On Sep 28, 2007, at 10:28 AM, Radhika S wrote:
> 20775 ? S 0:00 postgres: abc myDB [local] idle in
> transaction
> 20776 ? S 0:00 postgres: abc myDB [local] idle
> 17509 ? S 0:06 postgres: abc myDB [local] VACUUM
> waiting
> 24656 ? S 0:00 postgres: abc myDB [local] INSERT
> waiting
You're vacuum is probably waiting for the "idle in transaction"
session to finish, so it can clean up. It can't take a lock if your
transaction has locks. Your other tasks are probably waiting behind
the vacuum. Don't leave your transactions open for a long time. it
is bad.