Re: [ADMIN] Why is my table not autovacuuming?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [ADMIN] Why is my table not autovacuuming?
Дата
Msg-id CAKFQuwarsQaE80GjO0rz28Rhbt=vWo=-2s7T0_sMppAicm2_qg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Why is my table not autovacuuming?  (Joe Conway <mail@joeconway.com>)
Список pgsql-admin
On Mon, Aug 28, 2017 at 9:44 AM, Joe Conway <mail@joeconway.com> wrote:
Then at
​ ​
some point your server lost power. The info in the stats collector gets
reset on recovery.

Haven't pondered the vacuum side of the equation but ISTM if the auto-analyze daemon is confronted with total amnesia that it should go ahead and schedule an analyze on the entire database.  ANALYZE is relatively inexpensive.

And maybe learn some techniques to compensate.  Like copying the most recent snapshot of its input data to some place that survives a crash-restart.​

Also:

(formula) "is compared to the total number of tuples inserted, updated, or deleted since the last ANALYZE."


Since there are other ways for the stats to reset beside running ANALYZE this sentence hides a critical and should be amended to be more accurate.

David J.

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: [ADMIN] Why is my table not autovacuuming?
Следующее
От: Don Seiler
Дата:
Сообщение: [ADMIN] Standby: Use WAL instead of Streaming for now