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.
