From: Ron
Subject: Re: SCSI vs SATA
Date: ,
Msg-id: E1HYsBX-0006ZE-JG@elasmtp-banded.atl.sa.earthlink.net
(view: Whole thread, Raw)
In response to: Re: SCSI vs SATA  (Ron)
Responses: Re: SCSI vs SATA  (Geoff Tolley)
List: pgsql-performance

Tree view

SCSI vs SATA  ("", )
 Re: SCSI vs SATA  (Ron, )
  Re: SCSI vs SATA  (Ron, )
   Re: SCSI vs SATA  (Geoff Tolley, )
    Re: SCSI vs SATA  (, )
     Re: SCSI vs SATA  ("Peter Kovacs", )
      Re: SCSI vs SATA  (Andreas Kostyrka, )
       Re: SCSI vs SATA  (Alvaro Herrera, )
        Re: SCSI vs SATA  ("Peter Kovacs", )
         Re: SCSI vs SATA  (Alvaro Herrera, )
          Re: SCSI vs SATA  (Andreas Kostyrka, )
         Re: SCSI vs SATA  (, )
       Re: SCSI vs SATA  (Rod Taylor, )
     Re: SCSI vs SATA  (Geoff Tolley, )
    Re: SCSI vs SATA  ("", )
     Re: SCSI vs SATA  ("Joshua D. Drake", )
      Re: SCSI vs SATA  (Stefan Kaltenbrunner, )
       Re: SCSI vs SATA  ("Joshua D. Drake", )
        Re: SCSI vs SATA  (Stefan Kaltenbrunner, )
         Can't drop tablespace or user after disk gone  ("Craig A. James", )
          Re: Can't drop tablespace or user after disk gone  (Tom Lane, )
       Re: SCSI vs SATA  ("James Mansion", )
      Re: SCSI vs SATA  (Andreas Kostyrka, )
       Re: SCSI vs SATA  ("Joshua D. Drake", )
        Re: SCSI vs SATA  (, )
         Re: SCSI vs SATA  (Geoff Tolley, )
         Re: SCSI vs SATA  (Bruce Momjian, )
          Re: SCSI vs SATA  ("Joshua D. Drake", )
           Re: SCSI vs SATA  (Bruce Momjian, )
            Re: SCSI vs SATA  ("James Mansion", )
             Re: SCSI vs SATA  (Tom Lane, )
              Re: SCSI vs SATA  (Scott Marlowe, )
               Re: SCSI vs SATA  (Ron, )
                Re: SCSI vs SATA  (, )
                 Re: SCSI vs SATA  (Tom Lane, )
                  Re: SCSI vs SATA  (Greg Smith, )
                   Re: SCSI vs SATA  (Tom Lane, )
                    Re: SCSI vs SATA  (Geoffrey, )
                  Re: SCSI vs SATA  (Michael Stone, )
                   Re: SCSI vs SATA  (Geoffrey, )
               Re: SCSI vs SATA  ("James Mansion", )
                Re: SCSI vs SATA  (Scott Marlowe, )
                 Re: SCSI vs SATA  (, )
                  Re: SCSI vs SATA  (Ron, )
                   Re: SCSI vs SATA  (, )
                    Re: SCSI vs SATA  (Richard Troy, )
                    Re: SCSI vs SATA  (Ron, )
                     Re: SCSI vs SATA  (, )
                      Re: SCSI vs SATA  (Ron, )
                       Re: SCSI vs SATA  (Mark Kirkwood, )
                   Re: SCSI vs SATA  (Michael Stone, )
                    Re: SCSI vs SATA  (Ron, )
                     Re: SCSI vs SATA  (Michael Stone, )
                      Re: SCSI vs SATA  (Ron, )
                       Re: SCSI vs SATA  (Michael Stone, )
                        Re: SCSI vs SATA  (Ron, )
                         Re: SCSI vs SATA  (Michael Stone, )
                 Re: SCSI vs SATA  (Greg Smith, )
                  Re: SCSI vs SATA  (Scott Marlowe, )
                   Re: SCSI vs SATA  (Greg Smith, )
                   Re: SCSI vs SATA  (, )
                    Re: SCSI vs SATA  (Charles Sprickman, )
                     Re: SCSI vs SATA  (, )
                     Re: SCSI vs SATA  (Andreas Kostyrka, )
                   Re: SCSI vs SATA  (Bruce Momjian, )
                    Re: SCSI vs SATA  (Ron, )
                     Re: SCSI vs SATA  (, )
                      Re: SCSI vs SATA  (Ron, )
                       Re: SCSI vs SATA  (, )
                        Re: SCSI vs SATA  ("Joshua D. Drake", )
                        Re: SCSI vs SATA  (Ron, )
                       Re: SCSI vs SATA  (, )
                 Re: SCSI vs SATA  ("James Mansion", )
           Re: SCSI vs SATA  (Carlos Moreno, )
            Re: SCSI vs SATA  ("", )
             Re: SCSI vs SATA  (Arjen van der Meijden, )
             Re: SCSI vs SATA  (Heikki Linnakangas, )
             Re: SCSI vs SATA  (Ron, )
              Re: SCSI vs SATA  ("", )
               Re: SCSI vs SATA  ("Joshua D. Drake", )
               Re: SCSI vs SATA  ("Alex Deucher", )
               Re: SCSI vs SATA  (Arjen van der Meijden, )
               Re: SCSI vs SATA  (, )
     Re: SCSI vs SATA  (Geoff Tolley, )
     Re: SCSI vs SATA  (Scott Marlowe, )
      Re: SCSI vs SATA  (Jeff Frost, )
       Re: SCSI vs SATA  ("", )
 Re: SCSI vs SATA  ("Brian A. Seklecki", )
 Re: SCSI vs SATA  (Ron Mayer, )
 Re: SCSI vs SATA  (Ron, )
 Re: SCSI vs SATA  (Arjen van der Meijden, )
  Re: SCSI vs SATA  ("", )
   Re: SCSI vs SATA  (Arjen van der Meijden, )

At 07:07 PM 4/3/2007, Ron wrote:
>For random IO, the 3ware cards are better than PERC
>
> > Question: will 8*15k 73GB SCSI drives outperform 24*7K 320GB SATA
> II drives?
>
>Nope.  Not even if the 15K 73GB HDs were the brand new Savvio 15K screamers.
>
>Example assuming 3.5" HDs and RAID 10 => 4 15K 73GB vs 12 7.2K 320GB
>The 15K's are 2x faster rpm, but they are only ~23% the density =>
>advantage per HD to SATAs.
>Then there's the fact that there are 1.5x as many 7.2K spindles as
>15K spindles...
Oops make that =3x= as many 7.2K spindles as 15K spindles...


>Unless your transactions are very small and unbuffered / unscheduled
>(in which case you are in a =lot= of trouble), The SATA set-up rates
>to be ~2x - ~3x faster ITRW than the SCSI set-up.
...which makes this imply that the SATA set-up given will be ~4x -
~6x faster ITRW than the SCSI set-up given.

>Cheers,
>Ron Peacetree
>
>
>At 06:13 PM 4/3/2007,  wrote:
>>We need to upgrade a postgres server. I'm not tied to these specific
>>alternatives, but I'm curious to get feedback on their general
>>qualities.
>>
>>SCSI
>>   dual xeon 5120, 8GB ECC
>>   8*73GB SCSI 15k drives (PERC 5/i)
>>   (dell poweredge 2900)
>>
>>SATA
>>   dual opteron 275, 8GB ECC
>>   24*320GB SATA II 7.2k drives (2*12way 3ware cards)
>>   (generic vendor)
>>
>>Both boxes are about $8k running ubuntu. We're planning to setup with
>>raid10. Our main requirement is highest TPS (focused on a lot of
>>INSERTS).
>>
>>Question: will 8*15k SCSI drives outperform 24*7K SATA II drives?
>>
>>-jay
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Have you searched our list archives?
>>
>>               http://archives.postgresql.org



pgsql-performance by date:

From: david@lang.hm
Date:
Subject: Re: SCSI vs SATA
From: "James Mansion"
Date:
Subject: Re: compact flash disks?