Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 67CEA9F9E4E
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  5 Sep 2007 05:20:36 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 27961-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  5 Sep 2007 05:20:29 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id CF8089F9469
	for <pgsql-performance@postgresql.org>;
	Wed,  5 Sep 2007 05:20:31 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id BA66431434; Wed,  5 Sep 2007 10:20:30 +0200 (MET DST)
From: Hannes Dorbath <light@theendofthetunnel.de>
X-Newsgroups: pgsql.performance
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: Wed, 05 Sep 2007 10:20:31 +0200
Organization: Hub.Org Networking Services
Lines: 18
Message-ID: <46DE66CF.9000903@theendofthetunnel.de>
References: <fbkn5d$cfq$1@news.hub.org>
 <20070904230639.GA23731@alvh.no-ip.org>
	<dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
To: Scott Marlowe <scott.marlowe@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.8.1.6) Gecko/20070728 Thunderbird/2.0.0.6 Mnenhy/0.7.5.0
In-Reply-To: <dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com>
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.293 tagged_above=0 required=5 tests=AWL=0.292,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200709/36
X-Sequence-Number: 26581

On 05.09.2007 01:15, Scott Marlowe wrote:
> On 9/4/07, Alvaro Herrera <alvherre@commandprompt.com> wrote:
>> Carlo Stonebanks wrote:
>>> A client is moving their postgresql db to a brand new Windows 2003 x64
>>> server with 2 quad cores and 32GB of RAM. It is a dedicated server to run
>>> 8.2.4.
>> Large shared_buffers and Windows do not mix.  Perhaps you should leave
>> the shmem config low, so that the kernel can cache the file pages.
> 
> But yeah, the I/O, that's the big one.  If it's just a single or a
> couple of IDE drives, it's not gonna be able to handle much load.

Right, additionally NTFS is really nothing to use on any serious disc array.


-- 
Regards,
Hannes Dorbath