Re: autovacuum locking question

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: autovacuum locking question
Дата
Msg-id CAHOFxGqq6O6UGH08-kqeMBKeqhYzLu2b0QtQ4p1DJG-GFL7Vxg@mail.gmail.com
обсуждение исходный текст
Ответ на autovacuum locking question  (Mike Schanne <mschanne@kns.com>)
Ответы RE: autovacuum locking question  (Mike Schanne <mschanne@kns.com>)
Список pgsql-performance
Дерево обсуждения
On Thu, Dec 5, 2019 at 3:26 PM Mike Schanne <mschanne@kns.com> wrote:

I am concerned that if the autovacuum is constantly canceled, then the table never gets cleaned and its performance will continue to degrade over time.  Is it expected for the vacuum to be canceled by an insert in this way?

 

We are using postgres 9.6.10.


Have you checked when the table was last autovacuumed in pg_stat_user_tables? If the autovacuum count is high and timestamp of last run is relatively current, then no reason for concern as far as I can figure.

Have you already configured (non-default values) for autovacuum options for your system or this table?

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

Предыдущее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud
Следующее
От: Mike Schanne
Дата:
Сообщение: RE: autovacuum locking question