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

Re: Connection Pooling Problems Dave Page

From: "James M Doherty PGADMIN" <jimmyd(at)jdoherty(dot)net>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Connection Pooling Problems Dave Page
Date: 2005-02-23 15:36:06
Message-ID: 008301c519bd$64048ba0$68363c90@ad.tri.sbc.com (view raw or flat)
Thread:
Lists: pgsql-odbc
DOES ANYONE HAVE ANY EXPERIENCE WITH THIS .... DAVE PAGE? ANYONE...

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

In response to

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2005-02-23 16:11:45
Subject: Re: Connection Pooling Problems Dave Page
Previous:From: Ramon DanieliDate: 2005-02-23 09:40:32
Subject: Re: ODBCVER > 0x0250

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