Re: replication_reserved_connections - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: replication_reserved_connections
Date
Msg-id 51F4F11B.7080501@joh.to
Whole thread Raw
In response to Re: replication_reserved_connections  (Atri Sharma <atri.jiit@gmail.com>)
List pgsql-hackers
On 28/07/2013 08:51, Atri Sharma wrote:
> I would generally in agree with sharing super user reserved connections with replication.One thing I would like to
exploreis if we could potentially add some sort of priority system for avoiding contention between super user threads
andreplication threads competing for the same connection.
 
>
> We could potentially add a GUC for specifying which has the higher priority.

This sounds an awful lot like it would have to scan through the list of 
existing connections, which I wanted to avoid.

Or maybe we could maintain a separate list of "reserved" connections, 
i.e. ones that were created when we were at max_connections - 
ReservedBackends?  We could quickly look through that list to see how 
many of which we have allowed.  Not sure if that's practical, though.



Regards,
Marko Tiikkaja



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: improve Chinese locale performance
Next
From: Greg Stark
Date:
Subject: Comparing toasted data (was improve Chinese locale performance)