"Cassiano, Marco" wrote:
> "autovacuum_max_workers";"7"
> "autovacuum_naptime";"10min"
> "autovacuum_vacuum_cost_delay";"20ms"
> "autovacuum_vacuum_cost_limit";"200"
You've made autovacuum a little less aggressive for small,
heavily-updated tables with the 10min naptime, even with 7 workers.
Thank you Kevin,
here is the result of the query :
"version";"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit"
"archive_command";"/usr/local/bin/walscript.sh %p %f"
"archive_mode";"on"
"autovacuum";"on"
"autovacuum_max_workers";"7"
