X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EF79DDB985 for ; Fri, 18 Nov 2005 08:58:45 -0400 (AST) 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 16590-03 for ; Fri, 18 Nov 2005 12:58:47 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 841DADB9E7 for ; Fri, 18 Nov 2005 08:58:40 -0400 (AST) Received: (qmail 15708 invoked from network); 18 Nov 2005 12:58:44 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 18 Nov 2005 12:58:44 -0000 In-Reply-To: <33c6269f0511171150j24f2dd2bq607b69994338aa9@mail.gmail.com> References: <200511161550.jAGFoCY09049@candle.pha.pa.us> <437B578C.4000309@boreham.org> <33c6269f0511171150j24f2dd2bq607b69994338aa9@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <012EB91C-667A-495F-B4F2-F14EE7162ABA@fastcrypt.com> Cc: David Boreham , pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: Hardware/OS recommendations for large databases ( Date: Fri, 18 Nov 2005 07:58:43 -0500 To: Alex Turner X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/347 X-Sequence-Number: 15604 On 17-Nov-05, at 2:50 PM, Alex Turner wrote: > Just pick up a SCSI drive and a consumer ATA drive. > > Feel their weight. > > You don't have to look inside to tell the difference. At one point stereo manufacturers put weights in the case just to make them heavier. The older ones weighed more and the consumer liked heavy stereos. Be careful what you measure. Dave > > Alex > > On 11/16/05, David Boreham wrote: >> >> >> I suggest you read this on the difference between enterprise/SCSI >> and >> desktop/IDE drives: >> >> http://www.seagate.com/content/docs/pdf/whitepaper/ >> D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf >> >> >> This is exactly the kind of vendor propaganda I was talking about >> and it proves my point quite well : that there's nothing specific >> relating >> to reliability that is different between SCSI and SATA drives >> cited in that >> paper. >> It does have a bunch of FUD such as 'oh yeah we do a lot more >> drive characterization during manufacturing'. >> >> >> >> > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >