Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 8BF4E632A52;
	Tue, 20 Apr 2010 22:40:21 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024)
	with ESMTP id 58768-01; Wed, 21 Apr 2010 01:39:53 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com
	[209.85.160.174])
	by mail.postgresql.org (Postfix) with ESMTP id AD531633128;
	Tue, 20 Apr 2010 22:40:10 -0300 (ADT)
Received: by gyg13 with SMTP id 13so3535835gyg.19
	for <multiple recipients>; Tue, 20 Apr 2010 18:40:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=z/a5vZBx7IbbZ+vCYQMH9QxymROzbNYDow1eSQt5w+M=;
	b=Ewx9TznGrX/EloIDRRPTUNbdCDHrPGXnvTtvVIXwqzbcsL2Rrw1VCQVnGA87PuDVdj
	pDdJMjNSaWyYPlAhjSsnMUxR/U7kI8w8oQF9Y/7xixUj0+FZM5oAMHBoiuwNRkNAkdfe
	qxmiDsJHWoGVFZVLH0Xy+EyfrKwStryQUTt7k=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=J05kXqt+R3F5wzWaZt2W2Nh3ZVMrmZwqeJayvuMN0bNlGDd0bSNIV0TsVLbkF62jON
	jJcRYe5UT4UvsYHlLabekjjWICLsDGNLnVvUP9aZtvljjjhD1M+hubSoemJiCgQOGUtn
	oXpqmnjjmtJ591d999TUwdkQ10C+VpXoDv0/w=
MIME-Version: 1.0
Received: by 10.100.142.12 with HTTP; Tue, 20 Apr 2010 18:40:09 -0700 (PDT)
In-Reply-To: <h2g603c8f071004200701jff98aca6sfd063608572e463@mail.gmail.com>
References: <3f0b79eb1003300152g5327eb47w8f9aecae6002b215@mail.gmail.com>
	<4BB4952D0200002500030333@gw.wicourts.gov>
	<4BB4DBEF.3010301@agliodbs.com>
	<o2m603c8f071004011058neb6e0ea1r1f5caccbb7c50402@mail.gmail.com>
	<k2i3f0b79eb1004012306xdfa88c1cudd77b61368c997ea@mail.gmail.com>
	<w2z603c8f071004191904yefcaba2fy1abc2020174a35c5@mail.gmail.com>
	<s2u3f0b79eb1004200247q2f1c35f0pc7bf4af306f3514c@mail.gmail.com>
	<j2r603c8f071004200352s5e175371z8bd42b9c18807fe@mail.gmail.com>
	<h2w3f0b79eb1004200647nc0aa56d8ibb4be9f2f00731f5@mail.gmail.com>
	<h2g603c8f071004200701jff98aca6sfd063608572e463@mail.gmail.com>
Date: Wed, 21 Apr 2010 10:40:09 +0900
Received: by 10.101.146.6 with SMTP id y6mr16898705ann.32.1271814009301; Tue,
	20 Apr 2010 18:40:09 -0700 (PDT)
Message-ID: <n2v3f0b79eb1004201840ze33123a9xd96c11525f32532e@mail.gmail.com>
Subject: Re: [HACKERS] Streaming replication document improvements
From: Fujii Masao <masao.fujii@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	Tom Lane <tgl@sss.pgh.pa.us>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	pgsql-docs@postgresql.org,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.449 tagged_above=-10 required=5 tests=AWL=-1.970,
	BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72
X-Spam-Level: 
X-Archive-Number: 201004/73
X-Sequence-Number: 5472

On Tue, Apr 20, 2010 at 11:01 PM, Robert Haas <robertmhaas@gmail.com> wrote=
:
>> 3. Your proposal
>> =A0 =A0Treat superuser replication connection like non-superuser one
>
> Well, only for this one very specific purpose. =A0I would adjust the
> docs like this:
>
> Determines the number of connection "slots" that are reserved for
> connections by PostgreSQL =A0superusers. At most max_connections
> connections can ever be active simultaneously. Whenever the number of
> active concurrent connections is at least max_connections minus
> superuser_reserved_connections, new connections will be accepted only
> for superusers, and no new replication connections will be accepted.
>
> I think that's pretty simple and clear.

Yeah, I'm sold.

Regards,

--=20
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center