Hello all,
I usually run "vaccumdb --all --analyze --quiet" as a part of my
daily maintenance. While reading up a little on vacuumdb, I saw a
reference to "autovacuum", which seemed interesting.
Apparently, by enabling autovacuum in postgresql.conf, there's a
deamon that will check if vacuuming is required or not, and run the
vacuuming process as needed.
Quick questions: Do I simply need to enable autovacuum in the
postgresql.conf file, or is there more to it? Will it vacuum all
databases, or do I need to specify which ones? If so, how?
--
Kind Regards,
Jan Danielsson
Te audire non possum. Musa sapientum fixa est in aure.
