"Joshua D. Drake" wrote:
> Bill wrote:
> > I am new to PostgreSQL and just beginning to learn the product. I
> > will probrobably be using it exclusively on Windows.
> >
> > I was surprised to learn that PostgreSQL creates a new process for
> > each connection. Doesn't this severely limit its scalability by
> > consuming resources rapidly on the server as the number of user
> > increases?
>
> The Windows version is not anywhere near as scalable as the unix
> versions. Depending on your hardware you will top out a Windows
> installation about about 350-400 connections. You can get more out of
> Windows by modifying the registry but I am unsure of how far it will
> go.
>
> I have Linux installations that happily hum along with 2000-5000
> connections.
>
> So in answer to your question, in general -- no the process
> methodology we use does not limit scalability and it makes our code
> base much simpler that the equivalent threading model.
>
> Sincerely,
>
> Joshua D. Drake
Thanks. How much memory does PostgreSQL consume with 2000 connections?
Which Linux distribution do you prefer?
--
.Bill.