Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"
Date
Msg-id 20190215133955.GA12954@alvherre.pgsql
Whole thread Raw
In response to Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-performance
Tree view 
On 2019-Feb-14, Mariel Cherkassky wrote:

> I meant the anaylze, if anaylze will run very often on the original table,
> arent there disadvantages for it ?

It'll waste time and resources pointlessly.  Don't do it -- it won't do
any good.


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

pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: autovacuum big table taking hours and sometimes seconds
Next
From: Andrew Gierth
Date:
Subject: Re: Performance regressions found using sqlfuzz