Re: [HACKERS] TODO Done. Superuser backend slot reservations

Neil Conway wrote:
> [only replying to -patches, this doesn't belong on -hackers AFAICS ]
>
> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > Added GUC superuser_reserved_connections such that non-superuser connections
> > are only acceptable in the first
> > (max_connections - superuser_reserved_connections) backend slots.
>
> I'd prefer that we not change the meaning of max_connections. I had in
> mind the following:
>
>         - max_connections denotes the # of "regular" connections to
>           the database (i.e. admin & non-admin)

Well, if you do that, then max_connections is really not max
connections, it is maximum connections minus admin_connections.  That
seems confusing.

I think I prefer just reserving 1-2 of the last slots.  The kernel's
proc code is the same;  if you specify a proc table of 150, it is 150,
with 149 and 150 reserved for root.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073