Re: Maximum number of concurrent users

"Scott Marlowe" wrote:

>On Mon, Aug 4, 2008 at 11:51 AM, Mathias Stjernström
><mathias(at)globalinn(dot)com> wrote:
>> Hi!
>>
>> I have no experience running postgreSQL under windows but when reading the
>> Windows FAQ (http://www.postgresql.org/docs/faqs.FAQ_windows.html#4.4)
>> Its seem like you can get in trouble with some of the libraries that
>> postgres uses.
>>
>> Regarding performance it's hard to tell because of all the different factors
>> like raid type/disk count/type of queries/indexes etc. etc.
>>
>> But it sounds like the machine is to weak to handle 1000 concurrent queries.
>
>Oh my, I missed the windows part. If you need to handle 1000
>concurrent queries, I can't think of any db I'd want to use on windows
>to do that. Even Oracle would advise you to run on some flavor of
>unix. Maybe MSSQL server can handle it.

Postgres cannot handle that on windows. See
<http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware>

Rainer