Re: replication_reserved_connections - Mailing list pgsql-hackers

From Andres Freund
Subject Re: replication_reserved_connections
Date
Msg-id 20130728185016.GA10876@alap2.anarazel.de
Whole thread Raw
In response to replication_reserved_connections  (Marko Tiikkaja <marko@joh.to>)
Responses Re: replication_reserved_connections
List pgsql-hackers
On 2013-07-28 02:23:47 +0200, Marko Tiikkaja wrote:
> While you could limit the number of connections for non-replication roles,
> that's not always possible or desirable.  I would like to introduce a way to
> reserve connection slots for replication.  However, it's not clear how this
> would work.  I looked at how superuser_reserved_connections is implented,
> and with small changes I could see how to implement two ideas:
> 
> Does anyone see a better way to do this?  I'm not too satisfied with either
> of these ideas.

Personally I think we should just shouldn't allow normal connections for
the backend slots added by max_wal_senders. They are internally *added*
to max_connections, so limiting that seems perfectly fine to me since
the system provides max_connections connections externally.

Hm... I wonder how that's managed for 9.4's max_worker_processes.

Greetings,

Andres Freund

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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Review: UNNEST (and other functions) WITH ORDINALITY
Next
From: Andrew Dunstan
Date:
Subject: Re: install libpq.dll in bin directory on Windows / Cygwin