Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80C9B64FE97 for ; Tue, 9 Dec 2008 21:57:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19040-07 for ; Tue, 9 Dec 2008 21:57:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay-1.mail.nethere.net (relay-1.mail.nethere.net [66.63.128.161]) by mail.postgresql.org (Postfix) with ESMTP id F28EB64FCED for ; Tue, 9 Dec 2008 21:57:01 -0400 (AST) Received: from scan-1.mail.nethere.net (scan-1.mail.nethere.net [66.63.128.132]) by relay-1.mail.nethere.net (Postfix) with ESMTP id 6201B28515; Tue, 9 Dec 2008 17:56:59 -0800 (PST) Received: from mta-1.mail.nethere.net by scan-1.mail.nethere.net with LMTP id QnIxdO-vrE28; Tue, 9 Dec 2008 17:56:59 -0800 (PST) Received: from lisa-james-computer.local (wsip-68-224-174-233.sd.sd.cox.net [68.224.174.233]) by mta-1.mail.nethere.net (Postfix) with ESMTP id 34C41F1811; Tue, 9 Dec 2008 17:56:58 -0800 (PST) Message-ID: <493F21E9.9010009@emolecules.com> Date: Tue, 09 Dec 2008 17:56:57 -0800 From: Craig James User-Agent: Thunderbird 2.0.0.18 (Macintosh/20081105) MIME-Version: 1.0 To: justin CC: pgsql-performance@postgresql.org Subject: Re: Need help with 8.4 Performance Testing References: <22285.1228862315@sss.pgh.pa.us> <493EFD07.4080201@emproshunts.com> In-Reply-To: <493EFD07.4080201@emproshunts.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/104 X-Sequence-Number: 32140 justin wrote: > Tom Lane wrote: >> Hmm ... I wonder whether this means that the current work on >> parallelizing I/O (the posix_fadvise patch in particular) is a dead >> end. Because what that is basically going to do is expend more CPU >> to improve I/O efficiency. If you believe this thesis then that's >> not the road we want to go down. >> >> regards, tom lane >> > What does the CPU/ Memory/Bus performance road map look like? > > Is the IO performance for storage device for what ever it be, going to > be on par with the above to cause this problem? Flash memory will become just a fourth layer in the memory caching system (on-board CPU, high-speed secondary cache, main memory, and persistent memory). The idea of external storage will probably disappear altogether -- computers will just have memory, and won't forget anything when you turn them off. Since most computers are 64 bits these days, all data and programs will just hang out in memory at all times, and be directly addressable by the CPU. The distinction between disk and memory arose from the fact that disks were large, slow devices relative to "core" memory and had to be connected by long wires, hence the need for I/O subsystems. As flash memory becomes mainstream, I expect this distinction to disappear. Craig