Re: Does cancelling autovacuum make you lose all the work it did?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Does cancelling autovacuum make you lose all the work it did?
Дата
Msg-id CAKFQuwZc7YjsLXZwMws9+wLA828RkYbiABfDtMJuqNL==F34Dg@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Does cancelling autovacuum make you lose all the work it did?  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Ответы Re: Does cancelling autovacuum make you lose all the work it did?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Дерево обсуждения
The custom here is to inline or bottom-post.

On Fri, Jun 12, 2020 at 10:41 AM Stephen Froehlich <s.froehlich@cablelabs.com> wrote:

No autovacuum or vacuum causes no user-visible or breaking changes of any kind … it does change the performance of the database backend, but that’s all.


Um...doesn't really answer the question and besides hitting the wrap-around limit causes the server to not start in multi-user mode which is surely a user-visible effect.  Performance is a user-visible effect too - the only thing it better not impact is the correctness of the results.

To answer the original question: vacuum's effects are basically immediate so work is not lost if it gets cancelled.

David J.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Stephen Froehlich
Дата:
Сообщение: RE: Does cancelling autovacuum make you lose all the work it did?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Does cancelling autovacuum make you lose all the work it did?