Wednesday, December 20, 2006

autoVACUUM in postgres

stats_start_collector = on
stats_row_level = on
autovacuum = on
autovacuum_naptime = 120

in postgresql.conf and
kill -1 the pid for postgres
using cat postmaster.pid

No comments: