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 explore is if we could potentially add
some sort of priority system for avoiding contention between super user threads
and replication 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
