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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] TODO Done. Superuser backend slot reservations
Дата
Msg-id 200208252331.g7PNVDX23720@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] TODO Done. Superuser backend slot reservations  (Neil Conway <neilc@samurai.com>)
Ответы Re: [HACKERS] TODO Done. Superuser backend slot reservations  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-patches
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

В списке pgsql-patches по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: [HACKERS] TODO Done. Superuser backend slot reservations
Следующее
От: Neil Conway
Дата:
Сообщение: revised patch for PL/PgSQL table functions