Subject: Re: [HACKERS] Streaming replication document improvements
From: Simon Riggs <simon@2ndQuadrant.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>, Tom Lane <tgl@sss.pgh.pa.us>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	Fujii Masao <masao.fujii@gmail.com>, pgsql-docs@postgresql.org,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
In-Reply-To: <4BB4EAB4.3020904@agliodbs.com>
References: <3f0b79eb1003300152g5327eb47w8f9aecae6002b215@mail.gmail.com>
	<t2m603c8f071003311852x3dd15512uc92e0865ba729548@mail.gmail.com>
	<g2z3f0b79eb1003311858y7f781c7u99e09e32c96aa79b@mail.gmail.com>
	<x2t603c8f071003311900v524ab37x44f9e52a2a69dc33@mail.gmail.com>
	<o2u3f0b79eb1003311914i6c9d896bic3d1b13152c6b0d8@mail.gmail.com>
	<4BB49B0C.1050901@enterprisedb.com>
	<j2t603c8f071004011018tbdcc5d17y1fe17b29ab08703c@mail.gmail.com>
	<19262.1270142946@sss.pgh.pa.us>
	<4BB4952D0200002500030333@gw.wicourts.gov>
	<4BB4DBEF.3010301@agliodbs.com>
	<o2m603c8f071004011058neb6e0ea1r1f5caccbb7c50402@mail.gmail.com>
	<4BB4EAB4.3020904@agliodbs.com>
Content-Type: text/plain
Date: Thu, 01 Apr 2010 23:55:46 +0100
Message-Id: <1270162546.5640.3227.camel@ebony>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Thu, 2010-04-01 at 11:49 -0700, Josh Berkus wrote:
> > The thing is, when dealing with new features, we reduce our overall
> > maintenance burden if we get it right the first time.  Obviously it's
> > too late for major changes, but minor adjustments to maintain the POLA
> > seem like exactly what we SHOULD be doing right now.
> 
> Oh, I agree.  Since we have a separate WALSender limit, it seems
> counter-intuitive and difficult-to-admin to have the WALSenders also
> limited by superuser_connections.  They should be their own separate
> connection pool, just like the other "background" processes.
> 
> However, if this was somehow infeasible, it wouldn't be hard to
> document.  That's all.

+1

-- 
 Simon Riggs           www.2ndQuadrant.com