Re: autovacuum: vacuum analyze vs autovacuum: vacuum

Поиск
Список
Период
Сортировка
От Keith
Тема Re: autovacuum: vacuum analyze vs autovacuum: vacuum
Дата
Msg-id CAHw75vugH4auJsrX-1YSfYJD0bxX4gpJhSRm4BvXaaTvNYQqOg@mail.gmail.com
обсуждение исходный текст
Ответ на autovacuum: vacuum analyze vs autovacuum: vacuum  (Artem Tomyuk <admin@leboutique.com>)
Ответы Re: autovacuum: vacuum analyze vs autovacuum: vacuum
Список pgsql-admin


On Tue, Mar 27, 2018 at 5:04 AM, Artem Tomyuk <admin@leboutique.com> wrote:
Hi, Gurus!


As i understand from documentation:

when the autovacuum: vacuum analyze will be triggered, it will delete dead tuples and than will analyze table
but
when the autovacuum: vacuum will be triggered it will only mark for deletion dead tubles.

Is it valid explanation for postgres 9.4?

Thanks


I believe that when the ANALYZE portion of autovacuum kicks in, it only does the analyze. Which is why it's frequently tuned to run more often than the VACUUM portion of autovacuum since it's less of a load.

Keith

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

Предыдущее
От: bala jayaram
Дата:
Сообщение: AWS Database Migration Errors Post migration
Следующее
От: Artem Tomyuk
Дата:
Сообщение: Re: autovacuum: vacuum analyze vs autovacuum: vacuum