Re: Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact.

2018-04-11 Thread Laurenz Albe
Raghavendra Rao J S V wrote: > Are you suggesting me to keep "autovacuum_vacuum_cost_limit" to zero or > " autovacuum_vacuum_scale_factor" to zero or both? Please clarify me. autovacuum_vacuum_cost_limit is effectively 100 by default. You could raise it to 2000 or more. If that does not take

Re: Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact.

2018-04-11 Thread Raghavendra Rao J S V
Thank you very much for your prompt response. I requested in my previous mail as , planning to make ' *autovacuum_vacuum_scale_factor*' value to *zero *and *autovacuum_vacuum_threshold *value to *150 * in postgreconf file. Are you suggesting me to keep "autovacuum_vacuum_cost_limit" to zero or