From: | Mike Benoit <mikeb(at)netnation(dot)com> |
---|---|
To: | Stephen <jleelim(at)xxxxxx(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SCSI vs. IDE performance test |
Date: | 2003-10-27 18:44:08 |
Message-ID: | 1067280247.22758.153.camel@mikeb.staff.netnation.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I just ran some benchmarks against a 10K SCSI drive and 7200 RPM IDE
drive here:
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(dot)l(dot)johnson(at)cox(dot)net> wrote in message
> news:1066837102(dot)12532(dot)176(dot)camel(at)haggis(dot)(dot)(dot)
> >
> http://hardware.devchannel.org/hardwarechannel/03/10/20/1953249.shtml?tid=20
> &tid=38&tid=49
> >
> > --
> > -----------------------------------------------------------------
> > Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-27 19:14:41 | Re: SCSI vs. IDE performance test |
Previous Message | Tom Lane | 2003-10-27 18:26:43 | Re: Retrieving a column comment |