Skip site navigation (1) Skip section navigation (2)

Re: Connection Pooling Problems Dave Page

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: James M Doherty PGADMIN <jimmyd(at)jdoherty(dot)net>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection Pooling Problems Dave Page
Date: 2005-02-23 16:11:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
--- James M Doherty PGADMIN <jimmyd(at)jdoherty(dot)net>


More information would be good.  Relevant code,
relevant extracts from log files.  What is the
application actually doing, when the problem occurs?

> Jim
>   ----- Original Message ----- 
>   From: James M Doherty PGADMIN 
>   To: pgsql-odbc(at)postgresql(dot)org 
>   Sent: Wednesday, February 16, 2005 12:18 PM
>   Subject: [ODBC] Connection Pooling Problems 
>   I have an application that uses the ODBC interface
> from a window XP machine. I have set connection
> pooling on the pgsql driver to on with
>   a timeout of 120 seconds. This is being called
> from an Excel spread sheet. When the user refreshes
> the spread sheet I get hundreds of 
>   connections logged in /var/log/messages from the
> user. There are about 200 queries which try to
> execute at close to the same time. 
>   As a temporary measure I have increased the number
> of simultaneous connections to 500 to support this,
> however it does not look like 
>   connection pooling is working correctly. Any ideas
> on how I might diagnose this, or is there a known
> fix for this type of problem.
>   I am running 7.4 and of the ODBC
> driver.
>   Thanks for any help you can give me !
>   Jim
>   James M Doherty
>   jim(at)jdoherty(dot)net 
>   Georgetown, TX 78626
>   "There is no luck without discipline" IRISH

Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.

In response to


pgsql-odbc by date

Next:From: James M Doherty PGADMINDate: 2005-02-23 16:25:21
Subject: Re: Connection Pooling Problems Dave Page
Previous:From: James M Doherty PGADMINDate: 2005-02-23 15:36:06
Subject: Re: Connection Pooling Problems Dave Page

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group