Re: Really bad diskio - Mailing list pgsql-performance

From Jeffrey W. Baker
Subject Re: Really bad diskio
Date
Msg-id 1121462254.29379.3.camel@toonses.gghcwest.com
Whole thread Raw
In response to Re: Really bad diskio  (Ron Wills <ron@rwsoft.ca>)
Responses Re: Really bad diskio  (Ron Wills <ron@rwsoft.ca>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Really bad diskio
Next
From: Ron Wills
Date:
Subject: Re: Really bad diskio