From: Joshua D. Drake <jd@commandprompt.com>
To: jason@ohloh.net <jason@ohloh.net>
Cc: Geoff Tolley <geoff@polimetrix.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: SCSI vs SATA
Date: Wed, 04 Apr 2007 08:16:26 -0700
Message-ID: <4613C14A.4020703@commandprompt.com> (raw)
In-Reply-To: <DF6C723E-7362-4173-8309-B8AAFC968E2C@ohloh.net>
References: <9C0858F5-0A48-4AF9-80FF-E4BA14F0F965@ohloh.net>
<E1HYs6Y-0008O5-SN@elasmtp-banded.atl.sa.earthlink.net>
<E1HYsBX-0006ZE-JG@elasmtp-banded.atl.sa.earthlink.net>
<4613053F.5070401@polimetrix.com>
<DF6C723E-7362-4173-8309-B8AAFC968E2C@ohloh.net>
>
> Good point. On another note, I am wondering why nobody's brought up the
> command-queuing perf benefits (yet). Is this because sata vs scsi are at
SATAII has similar features.
> par here? I'm finding conflicting information on this -- some calling
> sata's ncq mostly crap, others stating the real-world results are
> negligible. I'm inclined to believe SCSI's pretty far ahead here but am
> having trouble finding recent articles on this.
What I find is, a bunch of geeks sit in a room and squabble about a few
percentages one way or the other. One side feels very l33t because their
white paper looks like the latest swimsuit edition.
Real world specs and real world performance shows that SATAII performs,
very, very well. It is kind of like X86. No chip engineer that I know
has ever said, X86 is elegant but guess which chip design is conquering
all others in the general and enterprise marketplace?
SATAII brute forces itself through some of its performance, for example
16MB write cache on each drive.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, jason@ohloh.net, geoff@polimetrix.com
Subject: Re: SCSI vs SATA
In-Reply-To: <4613C14A.4020703@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox