Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BC5299FB2F5 for ; Wed, 7 Mar 2007 11:41:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 30421-05 for ; Wed, 7 Mar 2007 11:41:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.net-domino.com (mail.mochima.com [74.208.11.96]) by postgresql.org (Postfix) with ESMTP id 628B19FB2D9 for ; Wed, 7 Mar 2007 11:41:35 -0400 (AST) Received: from [127.0.0.1] (u15245314.onlinehome-server.com [74.208.11.96]) by mail.net-domino.com (8.13.7/8.13.6) with ESMTP id l27FfPQQ016317 for ; Wed, 7 Mar 2007 11:41:30 -0400 Message-ID: <45EEDED8.9000804@mochima.com> Date: Wed, 07 Mar 2007 10:48:40 -0500 From: Carlos Moreno User-Agent: Mozilla Thunderbird 1.0.8-1.1.fc4 (X11/20060501) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: compact flash disks? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Added-Header: Sample_milter accepted message X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.652 tagged_above=0 required=5 tests=AWL, BAYES_60, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/154 X-Sequence-Number: 23559 > > Much better to use flash RAM for read heavy applications. > Even there you have to be careful that seek performance, not > throughput, is what is gating your day to day performance with those > tables. Isn't precisely there where Flash disks would have *the* big advantage?? I mean, access time is severely held down by the *mechanical* movement of the heads to the right cylinder on the disk --- that's a brutally large amount of time compared to anything else happening on the computer (well, floppy disks aside, and things like trying-to-break-128-bit-encryption aside :-)). Or are these Flash disks so slow that they compare to the HD's latency figures? Carlos --