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

Connection Pooling Problems

From: "James M Doherty PGADMIN" <jimmyd(at)jdoherty(dot)net>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Connection Pooling Problems
Date: 2005-02-16 18:18:37
Message-ID: 00b301c51453$ef69da20$ (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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 !


James M Doherty
Georgetown, TX 78626
"There is no luck without discipline" IRISH PROVERB


pgsql-odbc by date

Next:From: Ramon DanieliDate: 2005-02-17 15:06:17
Subject: Re: Unix domain socket
Previous:From: Philippe LangDate: 2005-02-16 11:08:09
Subject: Re: Problems with ODBC and Access

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