Full Vacuum/Reindex vs autovacuum

Поиск
Список
Период
Сортировка
От Jason Long
Тема Full Vacuum/Reindex vs autovacuum
Дата
Msg-id 1289242252.2646.34.camel@localhost.fx60
обсуждение исходный текст
Ответы Re: Full Vacuum/Reindex vs autovacuum  (John R Pierce <pierce@hogranch.com>)
Re: Full Vacuum/Reindex vs autovacuum  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Дерево обсуждения 
I currently have Postgres 9.0 install after an upgrade.  My database is
relatively small, but complex.  The dump is about 90MB.

Every night when there is no activity I do a full vacuum, a reindex, and
then dump a nightly backup.

Is this optimal with regards to performance?  autovacuum is set to the
default.

--
Thank you for your time,

Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
http://www.octgsoftware.com
HJBug Founder and President
http://www.hjbug.com

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

Предыдущее
От: Jakub Ouhrabka
Дата:
Сообщение: Re: ERROR: Out of memory - when connecting to database
Следующее
От: Matthieu Huin
Дата:
Сообщение: temporary table as a subset of an existing table and indexes