Re: auto vacuum for opentaps

Ernesto Eduardo Medina Núñez escribió:

Hi,

> *autovacuum = on   *              # enable autovacuum subprocess?
> #autovacuum_naptime = 60                # time between autovacuum runs, in
> secs
> #autovacuum_vacuum_threshold = 1000     # min # of tuple updates before
>                                         # vacuum
> #autovacuum_analyze_threshold = 500     # min # of tuple updates before
> analyze
> #autovacuum_vacuum_scale_factor = 0.4   # fraction of rel size before vacuum
> #autovacuum_analyze_scale_factor = 0.2  # fraction of rel size before
> analyze

The thresholds and scale_factors that came with this release were too
conservative.  I suggest reducing them to 50 and 0.1, respectively.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.