When the vacuum full timed out, could the exclusive lock have been left set, leaving the database in an unusable state?
BTW, thanks. I removed the --full option.
Paul
Andrew Sullivan wrote:
On Thu, Nov 11, 2004 at 05:14:50PM -0500, Paul B. Anderson wrote:
/usr/bin/vacuumdb --all --full --analyze
^^^^^
You do realise that takes an exclusive lock, right? Why are you
doing VACUUM FULL? If your FSM is set right, you really shouldn't
need it for most cases.
A