Re: Postgres 7.4.2 hanging when vacuum full is run

[Vivek Khera <vivek@xxxxxxxxx>]

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.