Re: Shared memory changes in 9.4?

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Christoph Berg <cb(at)df7cb(dot)de>, Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Shared memory changes in 9.4?
Date: 2014-06-12 16:00:53
Message-ID: 20140612160053.GA5373@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

On 2014-06-12 11:08:35 -0400, Robert Haas wrote:
> On Thu, Jun 12, 2014 at 5:41 AM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> >> > With regard to Andres' proposal, I'm not that keen on setting
> >> > dynamic_shared_memory_type='none' by default.
> >
> > Note that I'm not proposing to disable the whole thing. Just that a
> > unset dynamic_shared_memory_type doesn't configure dsm. Initdb would
> > still configure it after probing.
>
> OK, I misunderstood your position; thanks for clarifying. I think
> that would be OK with me. To some degree, I think that the test setup
> is broken by design: while we try to maintain backward-compatibility
> for postgresql.conf files, there's never been any guarantee that an
> old postgresql.conf file will work on a newer server. For example, a
> whole lot of pre-8.4 users probably had max_fsm_pages and
> max_fsm_relations configured, and with 8.4, those settings went away.
> Fixing that kind of thing is an essential part of the upgrade process.

While I think I see where you're coming from I don't think these cases
are comparable. In this case commenting out the GUC can prevent the
server from starting. That's pretty odd imo.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message boca2608 2014-06-12 16:33:03 Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account
Previous Message John R Pierce 2014-06-12 15:59:48 Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-06-12 16:03:07 Re: Suppressing unused subquery output columns
Previous Message David Johnston 2014-06-12 15:32:49 Re: [9.3] Should we mention "set_config(...)" in 18.1.3 in Server Configuration?