Re: idle connection timeout ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: idle connection timeout ...
Date
Msg-id 12035.1035577066@sss.pgh.pa.us
Whole thread Raw
In response to Re: idle connection timeout ...  (Mike Mascari <mascarm@mascari.com>)
Responses Re: idle connection timeout ...  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Mike Mascari <mascarm@mascari.com> writes:
> [ extensive proposal for PROFILEs ]
> It seems like a nice project, particularly since it wouldn't 
> affect anyone that doesn't want to use it.

... except in the added overhead to do the resource accounting and check
to see if there is a restriction ...

> And whenever a new 
> resource limitation issue arrises, such as PL/SQL recursion 
> depth, a new attribute would be added to pg_profile to handle 
> the limitation...

I prefer GUC variables to table entries for setting stuff like recursion
limits; they're much lighter-weight to create and access, and you don't
need an initdb to add or remove a parameter.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: idle connection timeout ...
Next
From: Bruce Momjian
Date:
Subject: Time for RC1 soon?