Re: Connection Pooling...(Repost)...please do help.. - Mailing list pgsql-interfaces

From sk@pobox.com (Sanjay Arora)
Subject Re: Connection Pooling...(Repost)...please do help..
Date
Msg-id 3a3a4515.3642788@192.168.1.1
Whole thread Raw
In response to RE: Connection Pooling...(Repost)...please do help.. .  ("Clark, Joel" <jclark@lendingtree.com>)
List pgsql-interfaces
Thanks Joel,

Yes there is. But it only keeps your unused connections on for a given
amount of time, so as to avoid opening new connections when you open a
connection again within the stipulated time.

In our case, we keep the connection open till the application has any
forms open. Problem in this case is that multiple users from different
workstations are opening connections on the PG server on RH 6.2.

What we want to do is start closing connections from applications
after query and somehow pool the connections on the Linux server.

Would like comments on this strategy and a how-to on this....help?
anyone?

With best regards.

Sanjay.

On Wed, 13 Dec 2000 15:19:53 -0500, in
tci.lists.rdbms.postgresql.interfaces you wrote:

>I know that the ODBC "engine" on Win32-based systems is capable of
>performing connection pooling, but I am not sure if the driver has to
>support it or not...anyone?  Check the "Connection Pooling" tab on the ODBC
>admin window in control panel.  If you don't have one, you might try
>upgrading MDAC.
>
>Joel
>
>-----Original Message-----
>From: Sanjay Arora [mailto:sk@pobox.com]
>Sent: Wednesday, December 13, 2000 7:19 PM
>To: pgsql-interfaces@postgresql.org
>Subject: [INTERFACES] Connection Pooling...(Repost)...please do help...
>
>
>I am using postgreSQL v. 7.0.2 on RH Linux 6.2 on the server with VB6
>Application accessing the DB through postgrSQL ODBC driver v. 6.50.
>
>I want to pool my connections on the postgreSQL server. Can some people
>give me some pointers? Some Web Resources for studying this subject? My
>experience on connection pooling is limited to MTS in MS environs.
>
>With best regards.
>
>Sanjay.
>



pgsql-interfaces by date:

Previous
From: Manika dey
Date:
Subject: Trigger
Next
From: Bruce Momjian
Date:
Subject: Re: Re: more odbc patches