From: Scott Marlowe <scott.marlowe@gmail.com>
To: Kesavan <kesavan@emmeskay.com>
Cc: pgsql-admin@postgresql.org, Premshaw <premshaw@emmeskay.com>
Subject: Re: Maximum number of concurrent users
Date: Mon, 4 Aug 2008 11:46:07 -0600
Message-ID: <dcc563d10808041046h74afd953l81ba4209abcdecef@mail.gmail.com> (raw)
In-Reply-To: <489724F7.4060900@emmeskay.com>
References: <489724F7.4060900@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, kesavan@emmeskay.com, premshaw@emmeskay.com
Subject: Re: Maximum number of concurrent users
In-Reply-To: <dcc563d10808041046h74afd953l81ba4209abcdecef@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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