Diagnosing outdated auto analyze dates... - Mailing list pgsql-admin

From Wells Oliver
Subject Diagnosing outdated auto analyze dates...
Date
Msg-id CAOC+FBVjeBp9+GFCBgYw4YmrGMz=80A1VO-QY_8_pzkYAT_dvw@mail.gmail.com
Whole thread Raw
Responses Re: Diagnosing outdated auto analyze dates...  (Keith Fiske <keith.fiske@crunchydata.com>)
List pgsql-admin
A last_autoanalyze date in pg_stat_all_tables for a table we update every day is 3/26, another is 3/13 -- I feel strongly somehow these tables should be auto-analyzed and auto-vacuumed more often, and am wondering where to look first.

My autovacuum_analyze_threshold is 10, my autovacuum_vacuum_threshold is 25. 

How can I better understand why these tables are not more frequently being auto-analyzed and vacuumed?

Thank you.

--

pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: get metadata after hardware failure
Next
From: Keith Fiske
Date:
Subject: Re: Diagnosing outdated auto analyze dates...