Re: restore time: sort_mem vs. checkpoing_segments

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: restore time: sort_mem vs. checkpoing_segments
Дата
Msg-id 16240.22635.390707.785148@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на Re: restore time: sort_mem vs. checkpoing_segments  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-performance
>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:

BM> restore, even if there is no value to it being large during normal
BM> server operation.  Should that be decumented?


Yes, right alongside the recommendation to bump sort_mem, even though
in my tests sort_mem made no significant difference in restore time
going from 8m to 128m.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: restore time: sort_mem vs. checkpoing_segments
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: LIKE query running slow