[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] postgresql +AMD64 +big address spaces - does it work?
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2004-07-01 22:52:19
Message-ID: 6827.1088722339 () sss ! pgh ! pa ! us
[Download RAW message or body]

"Andy B" <abhousehuntRE-M--O--V-E@blueyonder.co.uk> writes:
> 1. set postgresql.conf->shared_buffers to a value like (40GB/8KB),

That is the very last thing you want to do (even if you could, which you
can't).  Let the OS manage the memory --- the kernel can do just fine at
caching large files in RAM.  I've never seen any evidence that it helps
to set shared_buffers higher than a few tens of thousands.

See the pgsql-performance archives for much more on this subject.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html
[prev in list] [next in list] [prev in thread] [next in thread]