X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 27062D1BC4D for ; Tue, 2 Mar 2004 23:05:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80714-03 for ; Tue, 2 Mar 2004 19:05:11 -0400 (AST) Received: from phaedrusdeinus.org (dsl092-130-239.chi1.dsl.speakeasy.net [66.92.130.239]) by svr1.postgresql.org (Postfix) with SMTP id BD93ED1BC5C for ; Tue, 2 Mar 2004 19:05:07 -0400 (AST) Received: (qmail 94085 invoked by uid 1001); 2 Mar 2004 23:25:41 -0000 Date: Tue, 2 Mar 2004 17:25:41 -0600 From: johnnnnnn To: "scott.marlowe" Cc: pgsql-performance@postgresql.org Subject: Re: Scaling further up Message-ID: <20040302232540.GA4102@performics.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/33 X-Sequence-Number: 5889 On Tue, Mar 02, 2004 at 02:16:24PM -0700, scott.marlowe wrote: > It's a common misconception that faster RPM drives are a lot faster, > when, in fact, their only speed advantage is slight faster seeks. > The areal density of faster spinning hard drives tends to be > somewhat less than the slower spinning drives, since the maximum > frequency the heads can work in on both drives, assuming the same > technology, is the same. I.e. the speed at which you can read data > off of the platter doesn't usually go up with a higher RPM drive, > only the speed with which you can get to the first sector. This would imply that an upgrade in drive RPM should be accompanied by a decrease in random_page_cost, correct? random_page_cost should be set with the following things taken into account: - seek speed - likelihood of page to be cached in memory by the kernel - anything else? Sorry, i realize this pulls the thread a bit off-topic, but i've heard that about RPM speeds before, and i just want some confirmation that my deductions are reasonable. -johnnnnnnnnnnn