Skip site navigation (1) Skip section navigation (2)

Re: Effective Cache Size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darcy Buskermolen <darcy(at)wavefire(dot)com>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Effective Cache Size
Date: 2004-08-24 19:07:23
Message-ID: 6404.1093374443@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Darcy Buskermolen <darcy(at)wavefire(dot)com> writes:
> I was thinking of changing the way EFC is handled, having it retrived via code 
> (much the same way top does it) rather than relying on the user to specify 
> the value.  This value would then be checked/updated every so often.

Even assuming that you can portably find out how much RAM is going to
kernel cache (which I do not believe), how do you know how much of it
is getting used for Postgres data as opposed to everything else?

At the moment I think that manual handling is sufficient anyway.  This
is a relatively low-impact parameter and it doesn't seem too important
to try to get it dead on.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Shahbaz JaveedDate: 2004-08-24 19:16:30
Subject: Re: AT TIME ZONE
Previous:From: Gaetano MendolaDate: 2004-08-24 18:39:37
Subject: Re: debuging postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group