Re: max_wal_senders must die - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: max_wal_senders must die
Date
Msg-id 201011130409.oAD496x22133@momjian.us
Whole thread Raw
In response to Re: max_wal_senders must die  (Josh Berkus <josh@agliodbs.com>)
Responses Re: max_wal_senders must die
List pgsql-hackers
Josh Berkus wrote:
> 
> > None of us know.  What I do know is that I don't want PostgreSQL to be
> > slower out of the box.
> 
> Understandable.  So it seems like the answer is getting replication down
> to one configuration variable for the common case.  That eliminates the
> cycle of "oops, need to set X and restart/reload" without paying
> performance penalties on standalone servers.

Right.  I propose that we set max_wal_senders to unlimited when
wal_level = hot_standby.  When they tell us they are using hot_standby
via wal_level, why make them change another setting (max_wal_senders)?

Basically, we don't need to turn everything on by default, but some
settings should trigger other behavior automatically.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: plan time of MASSIVE partitioning ...
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Improved parallel make support