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

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

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date: 2013-01-09 18:47:46
Message-ID: CAGTBQpYyXX0+6Q+2jD+_cMB+Udf5SdbfCgJN5L69Tb+Q5Z1_mA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Jan 9, 2013 at 3:39 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> 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.

Not really. I'm convinced, and not only for e_c_s, that
autoconfiguration is within the realm of possibility.

However, since such a statement holds little weight without a patch
attached, I've been keeping it to myself (until I can invest the
effort needed for that patch).

In any case, as eavesdroppers can infer a cryptographic key by timing
operations or measuring power consumption, I'm pretty sure postgres
can infer cost metrics and/or time sharing with clever
instrumentation. The trick lies in making such instrumentation
uninstrusive.


In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2013-01-09 18:58:21
Subject: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Previous:From: Josh BerkusDate: 2013-01-09 18:39:11
Subject: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers

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