Request a Demo
Home   >   mailing lists

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

From Mariel Cherkassky
Subject Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"
Date
Msg-id CA+t6e1=t7b-+E=GSUxQa-SVHmLUf8we0QTR6Gd0=rRkV6xaFSg@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-performance
Tree view
'but then I don't have accurate statistics on my toasted table..

On Fri, Feb 15, 2019, 3:39 PM Alvaro Herrera <alvherre@2ndquadrant.com wrote:
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: Benedict Holland
Date:
Subject: Re: constraint exclusion with ineq condition (Re: server hardware tuning.)
Next
From: Justin Pryzby
Date:
Subject: Re: constraint exclusion with ineq condition (Re: server hardwaretuning.)