Re: autovacuum on a -mostly- r/o table

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: autovacuum on a -mostly- r/o table
Дата
Msg-id 200609270913.22644@hal.medialogik.com
обсуждение исходный текст
Ответ на autovacuum on a -mostly- r/o table  (Edoardo Ceccarelli <eddy@axa.it>)
Список pgsql-performance
On Wednesday 27 September 2006 09:08, Edoardo Ceccarelli <eddy@axa.it>
wrote:
>
> How can I configure the vacuum to run after the daily batch
> insert/update?
>

If you really only want it to run then, you should disable autovacuum and
continue to run the vacuum manually.

You might also investigate the vacuum cost delay options, which will make
vacuum take longer but will have less of an impact on your database while
running.


--
"If a nation values anything more than freedom, it will lose its freedom;
and the irony of it is that if it is comfort or money that it values more,
it will lose that too." -- Somerset Maugham, Author


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

Предыдущее
От: Edoardo Ceccarelli
Дата:
Сообщение: autovacuum on a -mostly- r/o table
Следующее
От: Tobias Brox
Дата:
Сообщение: Re: autovacuum on a -mostly- r/o table