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