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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] TODO Done. Superuser backend slot reservations
Date: 2002-08-25 23:31:13
Message-ID: 200208252331.g7PNVDX23720@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Neil Conway wrote:
> [only replying to -patches, this doesn't belong on -hackers AFAICS ]
>
> "Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nigel J. Andrews 2002-08-25 23:59:01 Re: [HACKERS] TODO Done. Superuser backend slot reservations
Previous Message Neil Conway 2002-08-25 23:26:06 Re: [HACKERS] TODO Done. Superuser backend slot reservations

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2002-08-25 23:57:47 revised patch for PL/PgSQL table functions
Previous Message Neil Conway 2002-08-25 23:26:06 Re: [HACKERS] TODO Done. Superuser backend slot reservations