Re: Mapping a database completly into Memory

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

BM> I think it all depends on your working set.  Having shared memory be
BM> smaller than you working set causes pages to have to be copied in from
BM> the kernel buffers (not a huge problem, but a small penalty), while
BM> having shared memory larger than the working set causes overhead of
BM> searching through all those buffers.

i.e., It is a black art, and no single piece of advice can be taken in
isolation ;-(


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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Possible problem with DOMAIN evaluation?
Следующее
От: "Jianshuo Niu"
Дата:
Сообщение: Help on my database performance