Eric Hiller wrote:
Very cool, that worked wonders for me, back to about the same
speed(maybe a little slower but it should speed up over time as you
said). Also, it halved the physical size of the database. for my ~130
users it took ~20minutes to run VACUUM FULL ANALYZE;
What is required to make it VACUUM ANALYZE every night?
Thanks for all the help!
postgres.conf
make sure you have at least:
stats_start_collector = on
stats_row_level = on
autovacuum = on # enable autovacuum subprocess?
Watch the logs. They'll tell you if autovacuum is running or not.
