Re: postgresql +AMD64 +big address spaces - does it work?

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql +AMD64 +big address spaces - does it work?
Date: 2004-07-01 23:25:51
Message-ID: AJEKKAIECKNMBCEKADJPOEKJCIAA.glenebob@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "Andy B" <abhousehuntRE-M--O--V-E(at)blueyonder(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2004-07-02 00:29:25 Re: permissions
Previous Message Marc G. Fournier 2004-07-01 23:24:27 Re: pgFoundry Open For Business