Re: dynamic shared memory: wherein I am punished for good intentions

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: dynamic shared memory: wherein I am punished for good intentions
Date: 2013-10-10 19:13:56
Message-ID: 5256FC74.7000605@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 10/10/2013 02:35 PM, Robert Haas wrote:
> On Thu, Oct 10, 2013 at 2:21 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>>> Other votes? Other ideas?
>> 5) test and set it in initdb.
> Are you advocating for that option, or just calling out that it's
> possible? I'd say that's closely related to option #3, except at
> initdb time rather than run-time - and it might be preferable to #3
> for some of the same reasons discussed on the thread about tuning
> work_mem, namely, that having it change from one postmaster lifetime
> to the next might lead to user astonishment.

Mainly just to throw it into the mix, But like you I think it's probably
a better option than #3 for the reason you give. It also has the
advantage of keeping any probing code out of the backend.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2013-10-10 19:39:31 Re: dynamic shared memory: wherein I am punished for good intentions
Previous Message Marc Munro 2013-10-10 18:56:49 Re: [v9.4] row level security