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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
