X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 77FC15354F for ; Sat, 26 Mar 2005 09:59:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01565-07 for ; Sat, 26 Mar 2005 09:59:33 +0000 (GMT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id AC13C538A7 for ; Sat, 26 Mar 2005 09:59:32 +0000 (GMT) Received: from ip96.85.1311c-cud12k-02.ish.de ([62.143.85.96] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1DF84c-0007AT-00; Sat, 26 Mar 2005 10:59:18 +0100 Received: from ip19.1.1411j-cud12k-02.ish.de ([62.143.1.19] helo=[192.168.100.5]) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1DF84b-0005oS-00; Sat, 26 Mar 2005 10:59:17 +0100 Message-ID: <42453273.2060509@turtle-entertainment.de> Date: Sat, 26 Mar 2005 10:59:15 +0100 From: Bjoern Metzdorf User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Steve Poe Cc: performance pgsql Subject: Re: How to improve db performance with $7K? References: <42443863.4040302@sfnet.cc> <4244B744.6020908@commandprompt.com> <4244A90B.2030200@sfnet.cc> In-Reply-To: <4244A90B.2030200@sfnet.cc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.889 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, NORMAL_HTTP_TO_IP, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200503/582 X-Sequence-Number: 11287 Hi Steve, > Okay. You trust SATA drives? I've been leary of them for a production > database. Pardon my ignorance, but what is a "battery backed cache"? I > know the drives have a built-in cache but I don't if that's the same. > Are the 12 drives internal or an external chasis? Could you point me to > a place that this configuration exist? Get 12 or 16 x 74GB Western Digital Raptor S-ATA drives, one 3ware 9500S-12 or two 3ware 9500S-8 raid controllers with a battery backup unit (in case of power loss the controller saves unflushed data), a decent tyan board for the existing dual xeon with 2 pci-x slots and a matching 3U case for 12 drives (12 drives internal). Here in Germany chassis by Chenbro are quite popular, a matching one for your needs would be the chenbro RM312 or RM414 (http://61.30.15.60/product/product_preview.php?pid=90 and http://61.30.15.60/product/product_preview.php?pid=95 respectively). Take 6 or 10 drives for Raid 10 pgdata, 2-drive Raid 1 for Transaction logs (xlog), 2-drive Raid 1 for OS and Swap, and 2 spare disks. That should give you about 250 mb/s reads and 70 mb/s sustained write rate with xfs. Regards, Bjoern