Обсуждение: Turning off revision tracking so vacuum never needs to be run

Поиск
Список
Период
Сортировка

Turning off revision tracking so vacuum never needs to be run

От
Mike Cianflone
Дата:
    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

От
Tom Lane
Дата:
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