"Magnus Naeslund\(f\)" <mag(at)fbab(dot)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
In response to
pgsql-hackers by date
|Next:||From: Alessio Bragadini||Date: 2001-06-06 14:53:43|
|Subject: Strange error, probably WAL-related|
|Previous:||From: Peter Eisentraut||Date: 2001-06-06 14:48:34|
|Subject: Re: SQL( "if ...exists...),how to do it in the PostgreSQL?|