Re: Mapping a database completly into Memory - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Mapping a database completly into Memory
Date
Msg-id 16169.9320.444739.336507@yertle.int.kciLink.com
Whole thread Raw
In response to Re: Mapping a database completly into Memory  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Possible problem with DOMAIN evaluation?
Next
From: "Jianshuo Niu"
Date:
Subject: Help on my database performance