Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date
Msg-id 50EDB94F.9030503@agliodbs.com
Whole thread Raw
In response to Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
List pgsql-hackers
Dimitri,

> It seems to me that pgfincore has the smarts we need to know about that,
> and that Cédric has code and refenrences for making it work on all
> platforms we care about (linux, bsd, windows for starters).

Well, fincore is Linux-only, and for that matter only more recent
versions of linux.  It would be great if we could just detect the RAM,
but then we *still* have to ask the user if this is a dedicated box or not.

> Then we could have a pretty decent snapshot of the information, and
> maybe a background worker of some sort would be able to refresh the
> information while the server is running.

I don't see a background worker as necessary or even desirable; people
don't frequently add RAM to their systems.  A manually callable command
would be completely adequate.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] unified frontend support for pg_malloc et al and palloc/pfree mulation (was xlogreader-v4)
Next
From: Claudio Freire
Date:
Subject: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers