From postgresql-general  Thu Jul 01 23:25:51 2004
From: "Glen Parker" <glenebob () nwlink ! com>
Date: Thu, 01 Jul 2004 23:25:51 +0000
To: postgresql-general
Subject: Re: [GENERAL] postgresql +AMD64 +big address spaces - does it work?
Message-Id: <AJEKKAIECKNMBCEKADJPOEKJCIAA.glenebob () nwlink ! com>
X-MARC-Message: https://marc.info/?l=postgresql-general&m=108872685711619

> "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.

My experience is the same; keep shared_buffers fairly small.

But I'm curious why we *can't* do 40GB on a 64 bit machine?  I'm testing an
AMD64 + FedoraCore2 + PG7.4 installation right now and I am expecting to
throw lots of memory at it soon...

Glen Parker


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings