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.