From: Jim C. Nasby <decibel@decibel.org>
To: Alex Turner <armtuk@gmail.com>
Cc: William Yu <wyu@talisys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: Wed, 6 Apr 2005 17:41:02 -0500
Message-ID: <20050406224102.GM93835@decibel.org> (raw)
In-Reply-To: <33c6269f050406151241b01148@mail.gmail.com>
References: <424840AE.3050200@sfnet.cc>
<op.sod768rgth1vuj@localhost>
<42494741.7060806@fastcrypt.com>
<33c6269f0504040643317b69cd@mail.gmail.com>
<42515198.9090903@sfnet.cc>
<33c6269f05040412126b5bc719@mail.gmail.com>
<d30377$1jn8$1@news.hub.org>
<33c6269f050406083533d2045d@mail.gmail.com>
<d31f71$2epm$1@news.hub.org>
<33c6269f050406151241b01148@mail.gmail.com>
Sorry if I'm pointing out the obvious here, but it seems worth
mentioning. AFAIK all 3ware controllers are setup so that each SATA
drive gets it's own SATA bus. My understanding is that by and large,
SATA still suffers from a general inability to have multiple outstanding
commands on the bus at once, unlike SCSI. Therefore, to get good
performance out of SATA you need to have a seperate bus for each drive.
Theoretically, it shouldn't really matter that it's SATA over ATA, other
than I certainly wouldn't want to try and cram 8 ATA cables into a
machine...
Incidentally, when we were investigating storage options at a previous
job we talked to someone who deals with RS/6000 storage. He had a bunch
of info about their serial controller protocol (which I can't think of
the name of) vs SCSI. SCSI had a lot more overhead, so you could end up
saturating even a 160MB SCSI bus with only 2 or 3 drives.
People are finally realizing how important bandwidth has become in
modern machines. Memory bandwidth is why RS/6000 was (and maybe still
is) cleaning Sun's clock, and it's why the Opteron blows Itaniums out of
the water. Likewise it's why SCSI is so much better than IDE (unless you
just give each drive it's own dedicated bandwidth).
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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: decibel@decibel.org, armtuk@gmail.com, wyu@talisys.com
Subject: Re: How to improve db performance with $7K?
In-Reply-To: <20050406224102.GM93835@decibel.org>
* 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