Re: Can i switch to the use of persistent connections with my already in use application without worrying ? - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Can i switch to the use of persistent connections with my already in use application without worrying ?
Date
Msg-id D4D1632DC736E74AB95FE78CD609007923B0F2@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Can i switch to the use of persistent connections with my already in use application without worrying ?  (Najib Abi Fadel <nabifadel@yahoo.com>)
List pgsql-general
Najib Abi Fadel wrote:

> i have an already running web application with a lot of users. All the
connections to the
> postgresql database are not persistent. I was wondering if it is
possible to switch to
> persistent connection without having problems in my current in
production application in
> order to boost performance ?

You don't mention how your web is constructed, but just about every
runtime platform has some kind of connection pooling.  For example, if
you are using Tomcat, then that has connection pools available.  You can
define them as part of your context, then just look them up when you
need a connection.

--
Guy Rouillier

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: Postgres Team: Thank You All
Next
From: Ben
Date:
Subject: powerset?