Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C6E969FB443 for ; Tue, 19 Jun 2007 14:10:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19558-01 for ; Tue, 19 Jun 2007 14:10:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 47ADE9FB6B8 for ; Tue, 19 Jun 2007 14:10:02 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 9CCEB74F0E; Tue, 19 Jun 2007 18:09:56 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 8A4872740D8; Tue, 19 Jun 2007 18:09:56 +0100 (BST) Message-ID: <46780DE4.1010007@archonet.com> Date: Tue, 19 Jun 2007 18:09:56 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: "Campbell, Lance" Cc: Francisco Reyes , pgsql-performance@postgresql.org Subject: Re: PostgreSQL Configuration Tool for Dummies References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/369 X-Sequence-Number: 25402 Campbell, Lance wrote: > Francisco and Richard, > Why ask about disk or raid? How would that impact any settings in > postgresql.conf? Well, random_page_cost will depend on how fast your disk system can locate a non-sequential page. If you have a 16-disk RAID-10 array that's noticably less time than a single 5400rpm IDE in a laptop. > I did forget the obvious question: > > What OS are you using? Tricky to keep simple, isn't it :-) -- Richard Huxton Archonet Ltd