Re: DB cache size strategies - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: DB cache size strategies
Date
Msg-id 20040211113031.GA30118@phlogiston.dyndns.org
Whole thread Raw
In response to Re: DB cache size strategies  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Feb 11, 2004 at 12:26:06AM -0500, Tom Lane wrote:
> Giving PG half the RAM is counterproductive no matter what --- that
> pretty much guarantees that every page that's in RAM will be in RAM
> twice, once in PG buffers and once in kernel buffers.  The two

Well, unless you're using an OS which allows you to set a nocache
option for a filesystem (Solaris allows this on UFS, for instance).
But the kernel cache, in my experience, is _still_ the winner,
because the LRU database cache isn't real efficient at large sizes.

--
Andrew Sullivan

pgsql-general by date:

Previous
From: Erwin Van de Velde
Date:
Subject: Converting timestamps and IP addresses
Next
From: Andrew Sullivan
Date:
Subject: Re: pg_class and relfilenode