"Magnus Naeslund\(f\)" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly