Re: Patch for reserved connections for replication users - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Patch for reserved connections for replication users
Date
Msg-id 20131015143424.GL5300@awork2.anarazel.de
Whole thread Raw
In response to Re: Patch for reserved connections for replication users  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Patch for reserved connections for replication users  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2013-10-15 10:29:58 -0400, Robert Haas wrote:
> On Tue, Oct 15, 2013 at 12:13 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> > If we think this way, then may be we should have max_user_connections
> > instead of max_connections and then max_wal_connections. But still
> > there are other's like pg_basebackup who needs connections and
> > tomorrow there can be new such entities which need connection.
> > Also we might need to have different infrastructure in code to make
> > these options available to users.
> > I think having different parameters to configure maximum connections
> > for different entities can complicate both code as well as user's job.
> 
> Renaming max_connections is far too big a compatibility break to
> consider without far more benefit than what this patch is aiming at.
> I'm not prepared to endure the number of beatings I'd have to take if
> we did that.

+many

> But I also agree that making max_wal_senders act as both a minimum and
> a maximum is no good.  +1 to everything Josh Berkus said.

Josh said we should treat replication connections in a separate "pool"
from normal database connections, right? So you withdraw your earlier
objection to that?

Greetings,

Andres Freund

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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Patch for reserved connections for replication users
Next
From: Bruce Momjian
Date:
Subject: Re: Release note fix for timeline item