Re: vacuumdb -a -z hangs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: vacuumdb -a -z hangs
Date
Msg-id 23841.991839178@sss.pgh.pa.us
Whole thread Raw
In response to vacuumdb -a -z hangs  ("Magnus Naeslund\(f\)" <mag@fbab.net>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SQL( "if ...exists...),how to do it in the PostgreSQL?
Next
From: Jan Wieck
Date:
Subject: Re: REPLACE INTO table a la mySQL