Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor" - Mailing list pgsql-performance

On 2019-Feb-13, Mariel Cherkassky wrote:

> Hey,
> I have a very big toasted table in my db(9.2.5).

Six years of bugfixes missing there ... you need to think about an
update.

> Autovacuum doesnt gather
> statistics on it because the analyze_scale/threshold are default and as a
> result autoanalyze is never run and the statistics are wrong :

analyze doesn't process toast tables anyway.

I think the best you could do is manually vacuum this table.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services