DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=Tr8Owvzx3OWGgUryj3IYgdexpic9MhR/NA11A3FakHu5skAVyqxjESmatDKqtu3sHs
	Mkf00pcxudBQ98JaMJcOII/9ucwfRoBcNBgF6LpnzhdiD0tMD8vNkwL7cfg3egaCl0uf
	DKEjtqjojfk1DxgoDQ4J4dz8mLpwA8nDrx2fE=
Message-ID: <dcc563d10808041530y66cd3035xabfa576a02860c09@mail.gmail.com>
Date: Mon, 4 Aug 2008 16:30:40 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "=?ISO-8859-1?Q?Mathias_Stjernstr=F6m?=" <mathias@globalinn.com>
Subject: Re: Maximum number of concurrent users
Cc: pgsql-admin@postgresql.org
In-Reply-To: <7CD0446A-37EC-4C4D-A796-D32F312E857B@globalinn.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <489724F7.4060900@emmeskay.com>
	<7CD0446A-37EC-4C4D-A796-D32F312E857B@globalinn.com>

On Mon, Aug 4, 2008 at 11:51 AM, Mathias Stjernstr=F6m
<mathias@globalinn.com> wrote:
> Hi!
>
> I have no experience running postgreSQL under windows but when reading th=
e
> 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 fact=
ors
> like raid type/disk count/type of queries/indexes etc. etc.
>
> But it sounds like the machine is to weak to handle 1000 concurrent queri=
es.

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.