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: 20050223161145.80692.qmail@web20821.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- James M Doherty PGADMIN <jimmyd(at)jdoherty(dot)net>
wrote:

> 
> DOES ANYONE HAVE ANY EXPERIENCE WITH THIS .... DAVE
> PAGE? ANYONE...

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 7.03.01.00 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
PROVERB



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250

In response to

Responses

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-2014 The PostgreSQL Global Development Group