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 C589552CB4 for ; Fri, 15 Jul 2005 18:18:56 -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 42126-10 for ; Fri, 15 Jul 2005 21:18:55 +0000 (GMT) Received: from gghcwest.com (adsl-71-128-90-172.dsl.pltn13.pacbell.net [71.128.90.172]) by svr1.postgresql.org (Postfix) with ESMTP id 173AE52CAE for ; Fri, 15 Jul 2005 18:18:54 -0300 (ADT) Received: from toonses.gghcwest.com (toonses.gghcwest.com [192.168.168.115]) by gghcwest.com (8.12.10/8.12.9) with ESMTP id j6FLIrmd026100; Fri, 15 Jul 2005 14:18:53 -0700 Received: from jwb by toonses.gghcwest.com with local (Exim 4.50) id 1DtXYt-0007eo-26; Fri, 15 Jul 2005 14:17:35 -0700 Subject: Re: Really bad diskio From: "Jeffrey W. Baker" To: Ron Wills Cc: pgsql-performance@postgresql.org In-Reply-To: <874qavbx24.wl%ron@rwsoft.ca> References: <8764vbby7r.wl%ron@rwsoft.ca> <42D82053.1090309@commandprompt.com> <874qavbx24.wl%ron@rwsoft.ca> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 15 Jul 2005 14:17:34 -0700 Message-Id: <1121462254.29379.3.camel@toonses.gghcwest.com> Mime-Version: 1.0 X-Mailer: Evolution 2.3.4 X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200507/227 X-Sequence-Number: 13468 On Fri, 2005-07-15 at 15:04 -0600, Ron Wills wrote: > At Fri, 15 Jul 2005 13:45:07 -0700, > Joshua D. Drake wrote: > > > > Ron Wills wrote: > > > Hello all > > > > > > I'm running a postgres 7.4.5, on a dual 2.4Ghz Athlon, 1Gig RAM and > > > an 3Ware SATA raid. > > > > 2 drives? > > 4 drives? > > 8 drives? > > 3 drives raid 5. I don't believe it's the raid. I've tested this by > moving the database to the mirrors software raid where the root is > found and onto the the SATA raid. Neither relieved the IO problems. Hard or soft RAID? Which controller? Many of the 3Ware controllers (85xx and 95xx) have extremely bad RAID 5 performance. Did you take any pgbench or other benchmark figures before you started using the DB? -jwb