Re: SCSI vs. IDE performance test

Mike Benoit <mikeb@netnation.com>

From: Mike Benoit <mikeb@netnation.com>
To: Stephen <jleelim@xxxxxx.com>
Cc: pgsql-general@postgresql.org
Date: 2003-10-27T18:44:08Z
Lists: pgsql-general
I just ran some benchmarks against a 10K SCSI drive and 7200 RPM IDE
drive here:

http://fsbench.netnation.com/

The results vary quite a bit, and it seems the file system you use
can make a huge difference. 

SCSI is obviously faster, but a 20% performance gain for 5x the cost is
only worth it for a very small percentage of people, I would think.

On Wed, 2003-10-22 at 09:01, Stephen wrote:
> The SCSI improvement over IDE seems overrated in the test. I would have
> expected at most a 30% improvement. Other reviews seem to point out that IDE
> performs just as well or better.
> 
> See Tom's hardware:
> http://www20.tomshardware.com/storage/20020305/index.html
> 
> Stephen
> 
> 
> "Ron Johnson" <ron.l.johnson@cox.net> wrote in message
> news:1066837102.12532.176.camel@haggis...
> >
> http://hardware.devchannel.org/hardwarechannel/03/10/20/1953249.shtml?tid=20
> &tid=38&tid=49
> >
> > --
> > -----------------------------------------------------------------
> > Ron Johnson, Jr. ron.l.johnson@cox.net
> > Jefferson, LA USA
> >
> > I can't make you have an abortion, but you can *make* me pay
> > child support for 18 years? However, if I want the child (and
> > all the expenses that entails) for the *rest*of*my*life*, and you
> > don't want it for 9 months, tough luck???
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
-- 
Best Regards,
 
Mike Benoit