Re: Connections sitting idle...

Raymond O'Donnell wrote:
>
> On 5 Dec 2002 at 11:53, Hiroshi Inoue wrote:
>
> > Yes IIS uses the connection pooling mechanism by default.
> > Pooled connections would be re-used if possible for other
> > sessions without re-establishing new connections.
>
> I should have mentioned that I turned off connection pooling for the
> PostgreSQL ODBC driver to see would it make a difference, but the
> backends hung around anyway.

IIS can use connection pooling by itself.

> On the production system I will use
> pooling - if the backends are there, hopefully they'll be re-used
> rather than having new ones opened. I still have to try this out.
>
> > Anyway I can't see other sessions' info at all in your
> > example. How do other sessions behave ?
>
> The same thing happens consistently.

I saw no other session's log in your example between
'select * from surveyowners' and the call for PGAPI_
Disconnect. I'm wondering how the number of connections
increased in such a situation.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/