X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 777515335B for ; Mon, 18 Apr 2005 15:19:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22752-07 for ; Mon, 18 Apr 2005 18:19:36 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by svr1.postgresql.org (Postfix) with ESMTP id 540B253359 for ; Mon, 18 Apr 2005 15:19:35 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so1544034wri for ; Mon, 18 Apr 2005 11:19:36 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OcsE2R77c+kOBV/LxX6FAYLe7KtFJudaG064mFzoDUfx3pOxLVGaQXQQIlp3/v0E3sBd4tth1Dyslh72t3BNrKsexdf/Spb5pf+TwXJ4Jsr7Rie47X3mv1agd/oVeWJcF4Xz/SbjnI9O/RAvfj07OD4aD3sC6OIPnC1AiXJ4Xog= Received: by 10.54.78.16 with SMTP id a16mr1177608wrb; Mon, 18 Apr 2005 11:19:36 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Mon, 18 Apr 2005 11:19:36 -0700 (PDT) Message-ID: <33c6269f05041811191e5047fd@mail.gmail.com> Date: Mon, 18 Apr 2005 14:19:36 -0400 From: Alex Turner Reply-To: Alex Turner To: Steve Poe Subject: Re: How to improve db performance with $7K? Cc: pgsql-performance@postgresql.org In-Reply-To: <4263F259.7030804@sfnet.cc> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <425EBA0C.6030804@sfnet.cc> <87pswsku6e.fsf@stark.xeocode.com> <33c6269f0504180817511b27a3@mail.gmail.com> <878y3gks3p.fsf@stark.xeocode.com> <33c6269f05041809566abf91d2@mail.gmail.com> <4263F259.7030804@sfnet.cc> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.276 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/420 X-Sequence-Number: 11817 I think the add more disks thing is really from the point of view that one disk isn't enough ever. You should really have at least four drives configured into two RAID 1s. Most DBAs will know this, but most average Joes won't. Alex Turner netEconomist On 4/18/05, Steve Poe wrote: > Alex, >=20 > In the situation of the animal hospital server I oversee, their > application is OLTP. Adding hard drives (6-8) does help performance. > Benchmarks like pgbench and OSDB agree with it, but in reality users > could not see noticeable change. However, moving the top 5/10 tables and > indexes to their own space made a greater impact. >=20 > Someone who reads PostgreSQL 8.0 Performance Checklist is going to see > point #1 add more disks is the key. How about adding a subpoint to > explaining when more disks isn't enough or applicable? I maybe > generalizing the complexity of tuning an OLTP application, but some > clarity could help. >=20 > Steve Poe >=20 >