Hi,

We are moving to postgres from Oarcle. When we were with Oracle, we were
using a total of 160 connections(4 app servers each maintaining a pool of 40
connections). After moving to postgres we want to make it higher i.e make it
60 connections for each app server i.e a total of 240 connections. How will
postgres behave with this many no of connections?

Thanks
Yuva
Sr. Java Developer
www.ebates.com

Tue, 23 Jul 2002 13:01:42 -0700
Yuva Chandolu <ychandolu@ebates.com>
Howmany connections postgres can handle upto?
On Tue, Jul 23, 2002 at 01:01:42PM -0700, Yuva Chandolu wrote:
> Hi,
> 
> We are moving to postgres from Oarcle. When we were with Oracle, we were
> using a total of 160 connections(4 app servers each maintaining a pool of 40
> connections). After moving to postgres we want to make it higher i.e make it
> 60 connections for each app server i.e a total of 240 connections. How will
> postgres behave with this many no of connections?

It rather depends.  For instance, are you running on a 386 with 4
megs of memory?  I expect that it won't work.  If you are running on
an 8-way Sun box with 16 gig of memory, I can report that you can
have 1024 connections without undue pain.

A

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


Tue, 23 Jul 2002 16:08:51 -0400
Andrew Sullivan <andrew@libertyrms.info>
Re: Howmany connections postgres can handle upto?