From: | "Bill" <postgresql(at)dbginc(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Scalability |
Date: | 2006-10-29 01:57:55 |
Message-ID: | ei11r2$22vo$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"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.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-10-29 02:17:30 | Re: Scalability |
Previous Message | Alexander Staubo | 2006-10-29 00:52:34 | Re: Scalability |