From: Alex Turner <armtuk@gmail.com>
To: Vivek Khera <vivek@khera.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: Mon, 4 Apr 2005 15:33:35 -0400
Message-ID: <33c6269f05040412336cbfe3b4@mail.gmail.com> (raw)
In-Reply-To: <cf58ceb65e6ab939e6c737cca23eef4c@khera.org>
References: <42443863.4040302@sfnet.cc>
<42455DEC.2080301@sfnet.cc>
<1112049794.23284.29.camel@localhost.localdomain>
<424840AE.3050200@sfnet.cc>
<op.sod768rgth1vuj@localhost>
<42494741.7060806@fastcrypt.com>
<33c6269f0504040643317b69cd@mail.gmail.com>
<42515198.9090903@sfnet.cc>
<33c6269f05040412126b5bc719@mail.gmail.com>
<cf58ceb65e6ab939e6c737cca23eef4c@khera.org>
I'm doing some research on SATA vs SCSI right now, but to be honest
I'm not turning up much at the protocol level. Alot of stupid
benchmarks comparing 10k Raptor drives against Top of the line 15k
drives, where usnurprsingly the SCSI drives win but of course cost 4
times as much. Although even in some, SATA wins, or draws. I'm
trying to find something more apples to apples. 10k to 10k.
Alex Turner
netEconomist
On Apr 4, 2005 3:23 PM, Vivek Khera <vivek@khera.org> wrote:
>
> On Apr 4, 2005, at 3:12 PM, Alex Turner wrote:
>
> > Our system is mostly read during the day, but we do a full system
> > update everynight that is all writes, and it's very fast compared to
> > the smaller SCSI system we moved off of. Nearly a 6x spead
> > improvement, as fast as 900 rows/sec with a 48 byte record, one row
> > per transaction.
> >
>
> Well, if you're not heavily multitasking, the advantage of SCSI is lost
> on you.
>
> Vivek Khera, Ph.D.
> +1-301-869-4449 x806
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
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: armtuk@gmail.com, vivek@khera.org
Subject: Re: How to improve db performance with $7K?
In-Reply-To: <33c6269f05040412336cbfe3b4@mail.gmail.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