TODO Done. Superuser backend slot reservations - Mailing list pgsql-hackers

From Nigel J. Andrews
Subject TODO Done. Superuser backend slot reservations
Date
Msg-id Pine.LNX.4.21.0208252339300.16637-200000@ponder.fairway2k.co.uk
Whole thread Raw
Responses Re: TODO Done. Superuser backend slot reservations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

TODO item:

Administration -
    Reserve last few process slots for super-user if max_connections
    reached


Notes:

Added GUC superuser_reserved_connections such that non-superuser connections
are only acceptable in the first
(max_connections - superuser_reserved_connections) backend slots.

Superuser connections within these first n slots count towards this
non-superuser connection limit. Therefore there can be at most this number
of non-superuser connections but may be less.

In addition, this limit is only checked on initialisation of a backend
process. So reserved slots can be taken by connections that subsequently
lose superuser priviledges thus evading the lower limit on backends.

Passed regression tests, not that it was likely not to.
Behaved as expected in a manual test.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fwd: Joins and links
Next
From: Bruce Momjian
Date:
Subject: Re: Database Caching