Re: DB cache size strategies

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DB cache size strategies
Date: 2004-02-11 11:30:31
Message-ID: 20040211113031.GA30118@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-02-11 11:47:09 Re: pg_class and relfilenode
Previous Message Erwin Van de Velde 2004-02-11 11:12:17 Converting timestamps and IP addresses