pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMaximum number of concurrent users
6+ messages / 5 participants
[nested] [flat]
* Maximum number of concurrent users
@ 2008-08-04 15:49 Kesavan <kesavan@emmeskay.com>
2008-08-04 17:03 ` Re: Maximum number of concurrent users Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-08-04 17:46 ` Re: Maximum number of concurrent users Scott Marlowe <scott.marlowe@gmail.com>
2008-08-04 17:51 ` Re: Maximum number of concurrent users Mathias Stjernström <mathias@globalinn.com>
0 siblings, 3 replies; 6+ messages in thread
From: Kesavan @ 2008-08-04 15:49 UTC (permalink / raw)
To: pgsql-admin; +Cc: Premshaw <premshaw@emmeskay.com>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Maximum number of concurrent users
2008-08-04 15:49 Maximum number of concurrent users Kesavan <kesavan@emmeskay.com>
@ 2008-08-04 17:03 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2 siblings, 0 replies; 6+ messages in thread
From: Kevin Grittner @ 2008-08-04 17:03 UTC (permalink / raw)
To: Kesavan <kesavan@emmeskay.com>; pgsql-admin; +Cc: Premshaw <premshaw@emmeskay.com>
>>> Kesavan <kesavan@emmeskay.com> wrote:
> In specific, can Postgres handle 1000 concurrent queries?
It can.
> We are using normal Pentium Quad core processor, 3GHZ system with 2GB
> RAM as Database Server.
With four processors, depending on your drive array configuration, you
are likely to get better performance funneling the requests through a
connection pool of about 8 to 16 connections. (With a lot of
spindles, maybe more.)
-Kevin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Maximum number of concurrent users
2008-08-04 15:49 Maximum number of concurrent users Kesavan <kesavan@emmeskay.com>
@ 2008-08-04 17:46 ` Scott Marlowe <scott.marlowe@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2008-08-04 17:46 UTC (permalink / raw)
To: Kesavan <kesavan@emmeskay.com>; +Cc: pgsql-admin@postgresql.org, Premshaw <premshaw@emmeskay.com>
On Mon, Aug 4, 2008 at 9:49 AM, Kesavan <kesavan@emmeskay.com> 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?
Sure. Give it enough hardware, and it can handle 1,000 concurrent
select field from table where pkey = 2345 type queries pretty well. I
wouldn't try to run 1,000 reporting queries hitting four tables with
1B to 1G to 1Tera rows or anything.
> 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.
Well, since we have no idea what your usage pattern will be, this
question is a little bit like "how many angels can dance on the head
of a pin?" i would put more memory in your server so it can fit in
memory easily. 4Gig should be enough. 8Gig would be more than
enough. But if you're running transactions. you're gonna have to tell
us what kind of drive subsystem you have, cause one drive won't handle
it.
Note that in transactional work, number of drives and their
configuration are probably more important than anything else.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Maximum number of concurrent users
2008-08-04 15:49 Maximum number of concurrent users Kesavan <kesavan@emmeskay.com>
@ 2008-08-04 17:51 ` Mathias Stjernström <mathias@globalinn.com>
2008-08-04 22:30 ` Re: Maximum number of concurrent users Scott Marlowe <scott.marlowe@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: Mathias Stjernström @ 2008-08-04 17:51 UTC (permalink / raw)
To: 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
Attachments:
PGP.sig (application/pgp-signature, 485B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Maximum number of concurrent users
2008-08-04 15:49 Maximum number of concurrent users Kesavan <kesavan@emmeskay.com>
2008-08-04 17:51 ` Re: Maximum number of concurrent users Mathias Stjernström <mathias@globalinn.com>
@ 2008-08-04 22:30 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-08-07 21:32 ` Re: Maximum number of concurrent users Rainer Bauer <usenet@munnin.com>
0 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2008-08-04 22:30 UTC (permalink / raw)
To: Mathias Stjernström <mathias@globalinn.com>; +Cc: pgsql-admin
On Mon, Aug 4, 2008 at 11:51 AM, Mathias Stjernström
<mathias@globalinn.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.
OTOH, 20 to 100 spindles on an 8 to 16 CPU machine might be able to
keep up if the queries are small enough and you use query pooling.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Maximum number of concurrent users
2008-08-04 15:49 Maximum number of concurrent users Kesavan <kesavan@emmeskay.com>
2008-08-04 17:51 ` Re: Maximum number of concurrent users Mathias Stjernström <mathias@globalinn.com>
2008-08-04 22:30 ` Re: Maximum number of concurrent users Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-08-07 21:32 ` Rainer Bauer <usenet@munnin.com>
0 siblings, 0 replies; 6+ messages in thread
From: Rainer Bauer @ 2008-08-07 21:32 UTC (permalink / raw)
To: pgsql-admin
"Scott Marlowe" wrote:
>On Mon, Aug 4, 2008 at 11:51 AM, Mathias Stjernström
><mathias@globalinn.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_wit...;
Rainer
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-08-07 21:32 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-04 15:49 Maximum number of concurrent users Kesavan <kesavan@emmeskay.com>
2008-08-04 17:03 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-08-04 17:46 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-08-04 17:51 ` Mathias Stjernström <mathias@globalinn.com>
2008-08-04 22:30 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-08-07 21:32 ` Rainer Bauer <usenet@munnin.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox