Re: Wrap around vacuum

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Wrap around vacuum
Дата
Msg-id 20090413235555.GL7709@alvh.no-ip.org
обсуждение исходный текст
Ответ на Wrap around vacuum  (elein <elein@varlena.com>)
Список pgsql-general
elein wrote:

Hi Elein,

> autovacuum does special stuff when there is an approaching transaction
> wrap around.
> We have a lot of transactions and wrap around as much as once a week.
>
> We'd like to invoke vacuum to do the special stuff explicitly so that we
> can do it during lower traffic times.  Like weekends rather than
> weekdays.

What release are we talking about?  8.1, 8.2 and 8.3 are all different
in this regard.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: elein
Дата:
Сообщение: Wrap around vacuum
Следующее
От: ahmed soua
Дата:
Сообщение: how to disable autovaccum