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
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 |
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 |