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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2013-01-09 18:58:21 | Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers |
Previous Message | Josh Berkus | 2013-01-09 18:39:11 | Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers |