Re: Maximum number of concurrent users - Mailing list pgsql-admin

From Mathias Stjernström
Subject Re: Maximum number of concurrent users
Date
Msg-id 7CD0446A-37EC-4C4D-A796-D32F312E857B@globalinn.com
Whole thread Raw
In response to Maximum number of concurrent users  (Kesavan <kesavan@emmeskay.com>)
Responses Re: Maximum number of concurrent users  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
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.

Best regards,
Mathias Stjernstrom
_____________________________________
Weblog at http://www.stjernstrom.se/


On 4 aug 2008, at 17.49, Kesavan wrote:

> Hi
>
> We are using PostgreSQL 8.3.1 version under windows.
> We want to know whether there is any limit on Maximum number of
> concurrent users.
> In specific, can Postgres handle 1000 concurrent queries?
> Regarding our Data size,
>
> We have 40 tables and in total we have 2GB data.
> We are using normal Pentium Quad core processor, 3GHZ system with
> 2GB RAM as Database Server.
>
> Kindly provide your inputs.
>
> Thanks in advance
> S.Kesavan
> Emmeskay Systems,
> Chennai, India.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin


Attachment

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Maximum number of concurrent users
Next
From: "Scott Marlowe"
Date:
Subject: Re: Maximum number of concurrent users