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 |
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 по дате отправления: