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