Re: 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