Re: Intel SRCS16 SATA raid?

От: Dave Held
Тема: Re: Intel SRCS16 SATA raid?
Дата: ,
Msg-id: 49E94D0CFCD4DB43AFBA928DDD20C8F9026184AF@asg002.asg.local
(см: обсуждение, исходный текст)
Ответ на: Intel SRCS16 SATA raid?  (Greg Stark)
Ответы: Re: Intel SRCS16 SATA raid?  (Alex Turner)
Re: Intel SRCS16 SATA raid?  (Alex Turner)
Список: pgsql-performance

Скрыть дерево обсуждения

Intel SRCS16 SATA raid?  (Greg Stark, )
 Re: Intel SRCS16 SATA raid?  ("Mohan, Ross", )
  Re: Intel SRCS16 SATA raid?  ("Joshua D. Drake", )
   Re: Intel SRCS16 SATA raid?  (Marinos Yannikos, )
    Re: Intel SRCS16 SATA raid?  (Alex Turner, )
     Re: Intel SRCS16 SATA raid? (somewhat OT)  (Marinos Yannikos, )
 Re: Intel SRCS16 SATA raid?  (, )
  Re: Intel SRCS16 SATA raid?  (Alex Turner, )
   Re: Intel SRCS16 SATA raid?  (Alex Turner, )
    Re: Intel SRCS16 SATA raid?  (, )
  Re: Intel SRCS16 SATA raid?  (Bruce Momjian, )
 Re: Intel SRCS16 SATA raid?  ("Dave Held", )
  Re: Intel SRCS16 SATA raid?  (Alex Turner, )
  Re: Intel SRCS16 SATA raid?  (Alex Turner, )
   Re: Intel SRCS16 SATA raid?  (Geoffrey, )
 Re: Intel SRCS16 SATA raid?  ("Dave Held", )
  Re: Intel SRCS16 SATA raid?  (, )
  Re: Intel SRCS16 SATA raid?  (Alex Turner, )
   Re: Intel SRCS16 SATA raid?  (, )
   Re: Intel SRCS16 SATA raid?  (Vivek Khera, )
    Re: Intel SRCS16 SATA raid?  (Alex Turner, )
 Re: Intel SRCS16 SATA raid?  ("Dave Held", )

> -----Original Message-----
> From: Alex Turner [mailto:]
> Sent: Thursday, April 14, 2005 12:14 PM
> To: 
> Cc: Greg Stark; ;
> 
> Subject: Re: [PERFORM] Intel SRCS16 SATA raid?
>
>
> I have put together a little head to head performance of a 15k SCSI,
> 10k SCSI 10K SATA w/TCQ, 10K SATA wo/TCQ and 7.2K SATA drive
> comparison at storage review
>
> http://www.storagereview.com/php/benchmark/compare_rtg_2001.ph
> p?typeID=10&testbedID=3&osID=4&raidconfigID=1&numDrives=1&devI
> D_0=232&devID_1=40&devID_2=259&devID_3=267&devID_4=261&devID_5
> =248&devCnt=6
>
> It does illustrate some of the weaknesses of SATA drives, but all in
> all the Raptor drives put on a good show.
> [...]

I think it's a little misleading that your tests show 0ms seek times
for some of the write tests.  The environmental test also selects a
missing data point as the winner.  Besides that, it seems to me that
seek time is one of the most important features for a DB server, which
means that the SCSI drives are the clear winners and the non-WD SATA
drives are the embarrassing losers.  Transfer rate is import, but
perhaps less so because DBs tend to read/write small blocks rather
than large files.  On the server suite, which seems to me to be the
most relevant for DBs, the Atlas 15k spanks the other drives by a
fairly large margin (especially the lesser SATA drives).  When you
ignore the "consumer app" benchmarks, I wouldn't be so confident in
saying that the Raptors "put on a good show".

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129


В списке pgsql-performance по дате сообщения:

От: Alex Turner
Дата:
Сообщение: Re: Intel SRCS16 SATA raid?
От: Geoffrey
Дата:
Сообщение: Re: Intel SRCS16 SATA raid?