X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 002EAD1B176 for ; Thu, 13 May 2004 18:01:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12210-10 for ; Thu, 13 May 2004 18:00:44 -0300 (ADT) Received: from roam.unifiedmind.com (unifiedmind.com [209.164.72.58]) by svr1.postgresql.org (Postfix) with SMTP id 37EBED1B17A for ; Thu, 13 May 2004 18:00:41 -0300 (ADT) Received: (qmail 27536 invoked from network); 13 May 2004 21:23:02 -0000 Received: from unknown (HELO jamesthornton.com) (james@65.65.104.48) by 0 with SMTP; 13 May 2004 21:23:02 -0000 Message-ID: <40A3E250.2020204@jamesthornton.com> Date: Thu, 13 May 2004 16:02:08 -0500 From: James Thornton User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bjoern Metzdorf Cc: pgsql-performance@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [PERFORM] Quad processor options - summary References: <40A2A7FA.6060403@turtle-entertainment.de> In-Reply-To: <40A2A7FA.6060403@turtle-entertainment.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/135 X-Sequence-Number: 13451 Bjoern Metzdorf wrote: > Hi, > > at first, many thanks for your valuable replies. On my quest for the > ultimate hardware platform I'll try to summarize the things I learned. > > ------------------------------------------------------------- > This is what I am considering the ultimate platform for postgresql: > > Hardware: > Tyan Thunder K8QS board > 2-4 x Opteron 848 in NUMA mode > 4-8 GB RAM (DDR400 ECC Registered 1 GB modules, 2 for each processor) > LSI Megaraid 320-2 with 256 MB cache ram and battery backup > 6 x 36GB SCSI 10K drives + 1 spare running in RAID 10, split over both > channels (3 + 4) for pgdata including indexes and wal. You might also consider configuring the Postgres data drives for a RAID 10 SAME configuration as described in the Oracle paper "Optimal Storage Configuration Made Easy" (http://otn.oracle.com/deploy/availability/pdf/oow2000_same.pdf). Has anyone delved into this before? -- James Thornton ______________________________________________________ Internet Business Consultant, http://jamesthornton.com