My Secenario :


P4 with 1G of memory on Fedora Core

about 100 inserts/update per hour

about 100 query per minute

20 concurrent connections



1. What is the best parameter setting in the pg_autovacuum for my scenario ?


2. what will be my sleep setting if i want to execute pg_autovacuum only after 10 hrs after the last execution.



Sorry for asking those stupid question but is this my first time to use pg_autovacuum and i can’t understand the

README.pg_autovacuum file :)


The default parameters in pg_autovacuum.h makes my box suffer some resources problem.




Reply via email to