Re: Maximum number of concurrent users

From: Mathias Stjernström <mathias(at)globalinn(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Maximum number of concurrent users
Date: 2008-08-04 17:51:44
Message-ID: 7CD0446A-37EC-4C4D-A796-D32F312E857B@globalinn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-08-04 22:30:40 Re: Maximum number of concurrent users
Previous Message Scott Marlowe 2008-08-04 17:46:07 Re: Maximum number of concurrent users