Re: SCSI vs. IDE performance test

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SCSI vs. IDE performance test
Date: 2003-10-24 14:23:43
Message-ID: 3F9935EF.9090509@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dann Corbit wrote:

>Unwrap this link (if your newsreader folds it) and click on it for hard
>drive performance:
>http://www.storagereview.com/php/benchmark/compare_rtg_2001.php?typeID=1
>0&testbedID=3&osID=4&raidconfigID=1&numDrives=1&devID_0=232&devID_1=237&
>devID_2=213&devID_3=221&devID_4=216&devID_5=249&devID_6=250&devCnt=7
>
>The important part for database is "Server Suite"
>
>---------------------------(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
>
>
>
Fairly old data, but it shows AMAZING differences in head seek time. I
didn't know head seeks were below 8ms for anything, even today. Also,
from what I've read, the SATA drives of those days were non existent?
The earliest SATA drives I've read about were just SATA interfaces on
OLDER IDE hardware - the manufacutrers had not really signed up on the
concept enough to put their good hardware underneath the interface.

--
"You are behaving like a man",
is an insult from some women,
a compliment from an good woman.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2003-10-24 14:53:30 Re: VACUUM degrades performance significantly. Database
Previous Message Adam Witney 2003-10-24 14:19:36 Re: shared memory on OS X - 7.4beta4