Re: vacuum strategy

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum strategy
Дата
Msg-id 7410.1038308521@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: vacuum strategy  (Tina Messmann <tina.messmann@xinux.de>)
Список pgsql-general
Tina Messmann <tina.messmann@xinux.de> writes:
> does this include the template1 database? So i have to vacuum the
> tempate1 database too on a regular  basis to avoid the rolling over of
> the transaction id?

Only if you're in the habit of modifying template1.

If you make occasional one-time changes to template1 (like, say,
installing plpgsql in it) you can do a "vacuum freeze" afterward
to make sure all is well; then you needn't include template1 in
your list of things to vacuum regularly.

            regards, tom lane

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

Предыдущее
От: "SZŰCS Gábor"
Дата:
Сообщение: Re: query visibility - trigger order - bug?
Следующее
От: Savita
Дата:
Сообщение: Re: COPY COMMAND