Re: Backends staying around - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Backends staying around
Date
Msg-id 3C0E123C.19756.2649F9@localhost
Whole thread Raw
In response to Re: Backends staying around  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On 5 Dec 2001, at 0:00, Martijn van Oosterhout wrote:

> Maybe you have some form of persistant connections? At least in unix,
> a socket is closed automatically when all processes owning the
> endpoint die off or close it.

Thanks for your reply! I have connection pooling turned on in ODBC
on the NT machine, but this is supposed to let clients re-use the
connections, so in theory at least the number of backends
shouldn't rise beyond a certain level - IIS always uses the same
username/password to connect to the database, so connection
pooling ought to be pretty efficient. I'll double-check how the
connections are handled in the COM components called from IIS.

--Ray.


---------------------------------------------------------
Raymond O'Donnell            http://www.iol.ie/~rod/organ
rod@iol.ie                      The Irish Pipe Organ Page
---------------------------------------------------------

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: MemoryContextAlloc: invalid request size
Next
From: Tielman J de Villiers
Date:
Subject: Selecting across Multiple Tables