Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers

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