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 583DB53360 for ; Mon, 28 Mar 2005 21:24:13 +0100 (BST) 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 68782-03 for ; Mon, 28 Mar 2005 20:24:04 +0000 (GMT) Received: from mail.tecarta.com (66.238.115.135.ptr.us.xo.net [66.238.115.135]) by svr1.postgresql.org (Postfix) with ESMTP id 5A74553351 for ; Mon, 28 Mar 2005 21:24:03 +0100 (BST) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Mon, 28 Mar 2005 12:27:00 -0800 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Mon, 28 Mar 2005 12:26:55 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005032812265518764 for ; Mon, 28 Mar 2005 12:26:55 -0800 X-ASG-Debug-ID: 1112041440-7339-0-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail2 (mail2.hq.corp [192.168.160.6]) by barracuda.tecarta.com (Spam Firewall) with SMTP id F008D2004907 for ; Mon, 28 Mar 2005 12:24:00 -0800 (PST) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Mon, 28 Mar 2005 12:26:51 -0800 Message-ID: <4247F48F.8090308@sfnet.cc> Date: Mon, 28 Mar 2005 12:11:59 +0000 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: Merlin Moncure , alex@neteconomist.com, pgsql-performance@postgresql.org X-ASG-Orig-Subj: Re: [PERFORM] which dual-CPU hardware/OS is fastest for PostgreSQL? Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL? References: <6EE64EF3AB31D5448D0007DD34EEB3412A75B4@Herge.rcsinc.local> <8764zb353a.fsf@stark.xeocode.com> In-Reply-To: <8764zb353a.fsf@stark.xeocode.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 28 Mar 2005 20:26:51.0923 (UTC) FILETIME=[79C90E30:01C533D4] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: -2.65 X-Barracuda-Spam-Status: No, SCORE=-2.65 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_01, DATE_IN_PAST_06_12 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.2208 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -3.50 BAYES_01 BODY: Bayesian spam probability is 1 to 10% [score: 0.0214] 0.85 DATE_IN_PAST_06_12 Date: is 6 to 12 hours before Received: date X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.336 tagged_above=0 required=5 tests=AWL, DATE_IN_PAST_06_12, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/611 X-Sequence-Number: 11316 Greg Stark wrote: >"Merlin Moncure" writes: > > > >>Alex wrote: >> >> >>>Without starting too much controvesy I hope, I would seriously >>>recommend you evaluate the AMCC Escalade 9500S SATA controller. >>> >>> >. > > >>At the risk of shaming myself with another 'me too' post, I'd like to >>say that my experiences back this up 100%. The Escalade controllers are >>excellent and the Raptor drives are fast and reliable (so far). >> >> >. > >I assume AMCC == 3ware now? > >Has anyone verified that fsync is safe on these controllers? Ie, that they >aren't caching writes and "lying" about the write completing like IDE >drives oft > > For those who speak highly of the Escalade controllers and/Raptor SATA drives, how is the database being utilized, OLTP or primarily read access? This is good information I am learning, but I also see the need to understand the context of how the hardware is being used. Steve Poe