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 44B69D1B4B0 for ; Wed, 3 Mar 2004 08:57:36 +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 24794-09 for ; Wed, 3 Mar 2004 04:57:21 -0400 (AST) Received: from anchor-post-37.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id 20850D1B4BB for ; Wed, 3 Mar 2004 04:57:19 -0400 (AST) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1AySBs-000CC7-0b for pgsql-performance@postgresql.org; Wed, 03 Mar 2004 08:57:20 +0000 Date: Wed, 3 Mar 2004 08:57:18 +0000 From: Paul Thomas To: "pgsql-performance @ postgresql . org" Subject: Re: Scaling further up Message-ID: <20040303085718.A24535@bacon> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com> <20040302232540.GA4102@performics.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <20040302232540.GA4102@performics.com>; from john@phaedrusdeinus.org on Tue, Mar 02, 2004 at 23:25:41 +0000 X-Mailer: Balsa 1.2.3 Lines: 25 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/38 X-Sequence-Number: 5894 On 02/03/2004 23:25 johnnnnnn wrote: > [snip] > random_page_cost should be set with the following things taken into > account: > - seek speed Which is not exactly the same thing as spindle speed as it's a combination of spindle speed and track-to-track speed. I think you'll find that a 15K rpm disk, whilst it will probably have a lower seek time than a 10K rpm disk, won't have a proportionately (i.e., 2/3rds) lower seek time. > - likelihood of page to be cached in memory by the kernel That's effective cache size. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+