autovacuum?

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-novice by date

  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