Re: limiting connections per user/database - Mailing list pgsql-patches

From Tom Lane
Subject Re: limiting connections per user/database
Date
Msg-id 29608.1119735686@sss.pgh.pa.us
Whole thread Raw
In response to limiting connections per user/database  (Petr Jelínek <pjmodos@parba.cz>)
Responses Re: limiting connections per user/database  (Petr Jelínek <pjmodos@parba.cz>)
List pgsql-patches
=?ISO-8859-2?Q?Petr_Jel=EDnek?= <pjmodos@parba.cz> writes:
> patch I attached allows to set connectin limits per user or per database
> (it's on TODO list).

I don't think this is going to work.  The first problem with it is that
it changes pgstats from an optional into a required part of the system.
The second is that since the pgstats output lags well behind the actual
state of the system, it'll be at best a very approximate limit on the
number of connections.  Perhaps for some people that's good enough, but
I kinda doubt it's what the people asking for the feature have in mind.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: COPY FROM performance improvements
Next
From: Petr Jelínek
Date:
Subject: Re: limiting connections per user/database