Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9E8D99F9D34 for ; Tue, 4 Sep 2007 20:15:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 99483-10 for ; Tue, 4 Sep 2007 20:15:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.191]) by postgresql.org (Postfix) with ESMTP id 6EF449F9CC4 for ; Tue, 4 Sep 2007 20:15:18 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so1189828rvb for ; Tue, 04 Sep 2007 16:15:17 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=iUe/DWZPC2EWhQlYBN0s/1Pe64kAcgXt+hBKjGmXoD/I5BbvirPDJDLJcNytF0XYaE74Nl7mEbXxq/iHJGnLJB1f+zukKM2NF7jILxKaOmx4jcj5QlxHsalQazGGbYpvlgEgPQ0QqGmsbKfvtqumrHAaqF/dbI8tc/D+odUFLOM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=TxRxwAS2vNxu7DMeQ3QdpLrifvdyisSJ/X1IWG85OHeTvsVMAHzNRcBOeQ9+eGPGwIdUtdXV+/3r1/lAS7Hgp8wAc973+FFkndfQRP30kqCThAPasYt49hUSMCwpTFMKe+7j1Vj4KawaI22nXkUhL6P33NvigKw6fPfTO0cgkx8= Received: by 10.141.20.7 with SMTP id x7mr827201rvi.1188947716878; Tue, 04 Sep 2007 16:15:16 -0700 (PDT) Received: by 10.141.159.11 with HTTP; Tue, 4 Sep 2007 16:15:16 -0700 (PDT) Message-ID: Date: Tue, 4 Sep 2007 18:15:16 -0500 From: "Scott Marlowe" To: "Alvaro Herrera" Subject: Re: Performance on 8CPU's and 32GB of RAM Cc: "Carlo Stonebanks" , pgsql-performance@postgresql.org In-Reply-To: <20070904230639.GA23731@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070904230639.GA23731@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/34 X-Sequence-Number: 26579 On 9/4/07, Alvaro Herrera 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. Egads, I'd completely missed the word Windows up there. I would highly recommend building the postgresql server on a unixish OS. Even with minimum tuning, I'd expect the same box running linux or freebsd to stomp windows pretty heavily in the performance department. 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.