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.