Well then there is a max - and it's the number of sockets limited by the OS
(some 32 in win9x, 64 in NT family, MAX_HANDLES or something on Linux)
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Jim" <jim@fortunet.com>
Cc: <pgsql-odbc@postgresql.org>
Sent: Sunday, January 26, 2003 10:25 PM
Subject: Re: [ODBC] Scalability in PostgreSQL
>
> No compiled in max. You can do thousands.
>
> --------------------------------------------------------------------------
-
>
> Jim wrote:
> > > Hi All,
> > >
> > > We are using PostgreSQL I want to know the scalability and concurrency
> > > controlb of postgreSQL.
> > >
> > > I want o know how many users can concurrently access postgreSQL.
> >
> > http://www.us.postgresql.org/docs/faq-english.html#3.8
> > default is 32, scalable up, but it doesn't mention what the max is post
> > version 6.5....
> >
> >
> >
> > >
> > > Your Quick response would be agreat value.
> > >
> > > Tnaks&rgds
> > > srihari
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
19073