Re: restore time: sort_mem vs. checkpoing_segments

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: restore time: sort_mem vs. checkpoing_segments
Дата
Msg-id Pine.LNX.4.44.0309240721430.352-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: restore time: sort_mem vs. checkpoing_segments  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-performance
On Tue, 23 Sep 2003, Bruce Momjian wrote:

> With the new warning about too-frequent checkpoints, people have actual
> feedback to encourage them to increase checkpoint_segments.  One issue
> is that it is likely to recommend increasing checkpoint_segments during
> restore, even if there is no value to it being large during normal
> server operation.  Should that be decumented?

One could have a variable that turns off that warning, and have pg_dump
insert a statement to turn it off. That is, if one never want these
warnings from a restore (from a new dump).

In any case, documentation is good and still needed.

--
/Dennis


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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: LIKE query running slow
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] osdl-dbt3 run results - puzzled by the execution