pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeffrey W. Baker <jwbaker@acm.org>
To: Ron Wills <ron@rwsoft.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Really bad diskio
Date: Fri, 15 Jul 2005 14:17:34 -0700
Message-ID: <1121462254.29379.3.camel@toonses.gghcwest.com> (raw)
In-Reply-To: <874qavbx24.wl%ron@rwsoft.ca>
References: <8764vbby7r.wl%ron@rwsoft.ca>
	<42D82053.1090309@commandprompt.com>
	<874qavbx24.wl%ron@rwsoft.ca>

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



view thread (12+ messages)  latest in thread

Message-ID: <1121462254.29379.3.camel@toonses.gghcwest.com>
Permalink:  ../1121462254.29379.3.camel@toonses.gghcwest.com/
Also on:    postgresql.org/message-id/1121462254.29379.3.camel@toonses.gghcwest.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jwbaker@acm.org, ron@rwsoft.ca
  Subject: Re: Really bad diskio
  In-Reply-To: <1121462254.29379.3.camel@toonses.gghcwest.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox