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 09C09D1B4C3 for ; Tue, 2 Mar 2004 21:27:12 +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 48920-03 for ; Tue, 2 Mar 2004 17:27:10 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 73F6CD1B4BA for ; Tue, 2 Mar 2004 17:27:08 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4528678; Tue, 02 Mar 2004 13:28:16 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Anjan Dave" , , "William Yu" Subject: Re: Scaling further up Date: Tue, 2 Mar 2004 13:26:19 -0800 User-Agent: KMail/1.5.4 Cc: References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com> In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403021326.19998.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/23 X-Sequence-Number: 5879 Anjan, > Question - Are 73GB drives supposed to give better performance because > of higher number of platters? Not for your situation, no. Your issue is random seek times for multiple simultaneous seek requests and batched checkpoint updates. Things that help with this are: More spindles Better controllers, both RAID and individual disks Faster drives Particularly, I'd check out stuff like reports from Tom's Hardware for evaluating the real speed of drives and seek times. Often a really good 10000 RPM SCSI will beat a 15000RPM SCSI if the latter has poor onboard programming. -- -Josh Berkus Aglio Database Solutions San Francisco