autovacuum?

Поиск
Список
Период
Сортировка
От Jan Danielsson
Тема autovacuum?
Дата
Msg-id 452FA0F3.7030604@gmail.com
обсуждение исходный текст
Ответы Re: autovacuum?  (Jan Danielsson <jan.danielsson@gmail.com>)
Re: autovacuum?  (Shane Ambler <pgsql@007Marketing.com>)
Список 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.


Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Laura Hornbeck"
Дата:
Сообщение: Re: FATAL: the database system is in recovery mode
Следующее
От: Jan Danielsson
Дата:
Сообщение: Re: autovacuum?