"Magnus Naeslund\(f\)" <mag@fbab.net> writes:
> I have a cronjob that does a vacuumdb -a -z every night.
> When i came to work this morning i saw a lot of postgres processes hanging
> on wait.
Sounds to me like you have an open transaction that is holding a lock
that everybody else needs. Very likely it's not the VACUUM that's at
fault, at least not directly.
regards, tom lane