Re: [ADMIN] Large transaction problem

[Paul B. Anderson]

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