From: Scott Marlowe <scott.marlowe@gmail.com>
To: Mathias Stjernström <mathias@globalinn.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Maximum number of concurrent users
Date: Mon, 4 Aug 2008 16:30:40 -0600
Message-ID: <dcc563d10808041530y66cd3035xabfa576a02860c09@mail.gmail.com> (raw)
In-Reply-To: <7CD0446A-37EC-4C4D-A796-D32F312E857B@globalinn.com>
References: <489724F7.4060900@emmeskay.com>
<7CD0446A-37EC-4C4D-A796-D32F312E857B@globalinn.com>
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.
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, mathias@globalinn.com
Subject: Re: Maximum number of concurrent users
In-Reply-To: <dcc563d10808041530y66cd3035xabfa576a02860c09@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