Re: How much log space does VACUUM need?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How much log space does VACUUM need?
Дата
Msg-id 7843.986599087@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How much log space does VACUUM need?  ("Gordon A. Runkle" <gar@integrated-dynamics.com>)
Список pgsql-general
"Gordon A. Runkle" <gar@integrated-dynamics.com> writes:
> Yet, when running VACUUM ANALYZE on this table, I run out of
> space.

Not sure if that should be construed as a bug or not; Vadim will have to
answer that.  But here's a thought: try increasing CHECKPOINT_TIMEOUT
and/or CHECKPOINT_SEGMENTS so that you don't get intermediate
checkpoints while the vacuum proceeds.  Should reduce the thing's
appetite for log space ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: monetary data type
Следующее
От: Marc Wrubleski
Дата:
Сообщение: update tables in remote db using trigger