Re: [ADMIN] Why is my table not autovacuuming? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: [ADMIN] Why is my table not autovacuuming?
Date
Msg-id CAKFQuwarsQaE80GjO0rz28Rhbt=vWo=-2s7T0_sMppAicm2_qg@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Why is my table not autovacuuming?  (Joe Conway <mail@joeconway.com>)
List 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 by date:

Previous
From: Joe Conway
Date:
Subject: Re: [ADMIN] Why is my table not autovacuuming?
Next
From: Don Seiler
Date:
Subject: [ADMIN] Standby: Use WAL instead of Streaming for now