Re: vacuum confusion

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum confusion
Дата
Msg-id 11276.1108138001@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: vacuum confusion  (John Sidney-Woollett <johnsw@wardbrook.com>)
Ответы Re: vacuum confusion  (John Sidney-Woollett <johnsw@wardbrook.com>)
Список pgsql-general
John Sidney-Woollett <johnsw@wardbrook.com> writes:
> However the implication (and my confusion) is that you need to vacuum
> your own databases only. It's not clear (to me) that you have to do the
> same for template0 and template1 as well.

You have to vacuum template1, but not template0 because the latter is
marked not datallowconn.  Not sure if this is adequately explained
anywhere.  The next-to-last para in section 21.1.3 does mention the
datallowconn exception, but perhaps doesn't spell it out well enough.

            regards, tom lane

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

Предыдущее
От: Mark
Дата:
Сообщение: how to capture query?
Следующее
От: Brad Nicholson
Дата:
Сообщение: Re: how to capture query?