Postgres Pro
Downloads
Home   >   mailing lists

Thread: jdbc connection pool settings

jdbc connection pool settings

From
Culley Harrelson
Date:
I'm in the process of implementing connection pooling
and the setup I'm using (http://www.javaexchange.com -
really slick!) has settings for min # connections and
max # connection.  Any suggestions on where I should
set these values?  min=2, max=6? My site will be
outside the firewall, open to the public for all to
trash.

Culley

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

Re: jdbc connection pool settings

From
Anand Raman
Date:
it depends on what kind of concurrent connections u will be getting..
For admin interfaces the kind of settingu mentioned might be OK but in
case it is a heavily loaded site then u need to think..

Anand


On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote:
>I'm in the process of implementing connection pooling
>and the setup I'm using (http://www.javaexchange.com -
>really slick!) has settings for min # connections and
>max # connection.  Any suggestions on where I should
>set these values?  min=2, max=6? My site will be
>outside the firewall, open to the public for all to
>trash.
>
>Culley
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail - only $35
>a year!  http://personal.mail.yahoo.com/

Re: jdbc connection pool settings

From
Peter T Mount
Date:
Quoting Culley Harrelson <culleyharrelson@yahoo.com>:

> I'm in the process of implementing connection pooling
> and the setup I'm using (http://www.javaexchange.com -
> really slick!) has settings for min # connections and
> max # connection.  Any suggestions on where I should
> set these values?  min=2, max=6? My site will be
> outside the firewall, open to the public for all to
> trash.

Although you're using JDBC here, this is actually a basic postgres admin
problem. The size of your pool would be based on what resources you have
available and how much traffic you're expecting.

Peter

>
> Culley
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year!  http://personal.mail.yahoo.com/
>



--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/