| From: | Jan Danielsson <jan(dot)danielsson(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | autovacuum? |
| Date: | 2006-10-13 14:21:39 |
| Message-ID: | 452FA0F3.7030604@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Danielsson | 2006-10-13 15:22:52 | Re: autovacuum? |
| Previous Message | Laura Hornbeck | 2006-10-12 18:37:45 | Re: FATAL: the database system is in recovery mode |