From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | Shaw Terwilliger <sterwill(at)sourcegear(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pooling Connections with libpq |
Date: | 2001-02-22 23:57:12 |
Message-ID: | 20010222155712.J29126@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Shaw Terwilliger <sterwill(at)sourcegear(dot)com> [010222 15:49] wrote:
> Alfred Perlstein wrote:
> > As a general safety precaution I would close a connection after a
> > timeout or N uses.
>
> My application is running on the same host as PostgreSQL, so connection
> timeouts should be rare (I guess this would only happen if a backend died).
> Re-opening the connection after N uses sounds like a reasonable precaution
> though.
I meant a user defined timeout, ie, a connection can only be recycled
100, 200 or 500 times (your choice) but can't be kept open for longer
than 5 minutes.
This is just for paranioa such that _if_ (there isn't as far as i
know) there's an issue with a backend leaking memory, you don't
get nailed by it.
> (Hopefully my PGP signatures are correct this time.)
PGP isn't really needed when having a general discussion .:)
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff | 2001-02-23 00:52:54 | CGI error |
Previous Message | Shaw Terwilliger | 2001-02-22 23:49:46 | Re: Pooling Connections with libpq |