Second Derivative Community Forum

edit /etc/postgresql/8.3/main/postgresql.conf

Change the following lines, watch the # signs in front. => means change to:

#superuser_reserved_connections = 3 => superuser_reserved_connections = 3
#stats_start_collector = on => stats_start_collector = on
stats_row_level = on => stats_row_level = on (just verify it is uncommented and on)
autovacuum = on => autovacuum = on (just verify it is uncommented and on)
#autovacuum_naptime = 1min => autovacuum_naptime = 1min
#autovacuum_vacuum_threshold = 500 => autovacuum_vacuum_threshold = 500
#autovacuum_analyze_threshold = 250 => autovacuum_analyze_threshold = 250
#autovacuum_vacuum_scale_factor = 0.2 => autovacuum_vacuum_scale_factor = 0.2
#autovacuum_analyze_scale_factor = 0.1 => autovacuum_analyze_scale_factor = 0.1
#autovacuum_freeze_max_age = 200000000 => autovacuum_freeze_max_age = 200000000
#autovacuum_vacuum_cost_delay = -1 => autovacuum_vacuum_cost_delay = -1
#autovacuum_vacuum_cost_limit = -1 => autovacuum_vacuum_cost_limit = -1

restart postgresql

Thanks Curtis to share tips and information about Simple enabling of autovacuum on PostgreSQL 8.2 system.I really need it.Thanks to share posts.Keep doing posts............