On Thu, Apr 29, 2010 at 1:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> That said, I'ld probalby be happy with PG 9 having a "default" config
>>> wal_mode = hot_standby
>>> recovery_connections = on
>> That would be a bad idea - there's a significant performance penalty
>> from setting wal_level to anything other than minimal (just as there
>> is for turning on archive_mode in 8.4).
> There is not only a performance penalty, but a reliability penalty.
> Enabling these switches turns on a whole lot of code that, with all
> due respect to those who have worked on it, is absolutely positively
> guaranteed to be full of bugs. Not all of which are going to be flushed
> out during beta. If we ship 9.0 with these things on by default, it
> will result in an immediate reliability downgrade for installations that
> are simply doing what they did before and not even interested in HS/SR.
This is a pretty good argument, and Heikki's argument just upthread
that a mismatched max_connections setting could bollix things is an
even better one. So I'm now changing my mind and thinking this should
be off by default, also.
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2010-04-29 17:21:36|
|Subject: Re: s/recovery_connections/allow_standby_queries/, or something like that?|
|Previous:||From: Tom Lane||Date: 2010-04-29 17:18:55|
|Subject: s/recovery_connections/allow_standby_queries/, or something like that?|
pgsql-committers by date
|Next:||From: Simon Riggs||Date: 2010-04-29 17:37:56|
|Subject: Re: Re: [COMMITTERS] pgsql: Make
CheckRequiredParameterValues() depend upon correct|
|Previous:||From: Kevin Grittner||Date: 2010-04-29 17:16:12|
|Subject: Re: Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct|