Re: pg_clog & vacuum oddness

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_clog & vacuum oddness
Дата
Msg-id 5274.1067445132@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_clog & vacuum oddness  (Jeff <threshar@torgo.978.org>)
Ответы Re: pg_clog & vacuum oddness
Список pgsql-admin
Jeff <threshar@torgo.978.org> writes:
> [ pg_clog not getting truncated ]

pg_clog is truncated on the basis of the oldest completely vacuumed
database in your installation.  Most likely your maintenance script
is failing to vacuum some database(s) (template1, perhaps?) and/or
is doing table-by-table vacuums rather than an unqualified VACUUM.

I doubt this explains any performance problems though.  Old pg_clog
segments don't do anything except sit there.

            regards, tom lane

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

Предыдущее
От: Jeff
Дата:
Сообщение: pg_clog & vacuum oddness
Следующее
От: Jeff
Дата:
Сообщение: Re: pg_clog & vacuum oddness