Turning off revision tracking so vacuum never needs to be run
Started by Mike Cianfloneover 24 years ago2 messages
I've followed the threads of needing to run vacuum nightly, and even
got an answer to a slow updating database regarding needing to vacuum. But I
haven't see the question asked:
is it possible to completely turn off the revision tracking feature so that
vacuum does not need to be run at all?
Thanks for any pointers,
Mike
Re: Turning off revision tracking so vacuum never needs to be run
Mike Cianflone <mcianflone@littlefeet-inc.com> writes:
is it possible to completely turn off the revision tracking feature so that
vacuum does not need to be run at all?
No.
Of course, if you never update or delete any rows, you don't need VACUUM
... but I suspect that's not what you had in mind.
regards, tom lane