Re: Reliability recommendations - Mailing list pgsql-performance

From Ron
Subject Re: Reliability recommendations
Date
Msg-id 7.0.1.0.2.20060225063934.00adfec0@earthlink.net
Whole thread Raw
In response to Re: Reliability recommendations  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-performance
At 01:22 AM 2/25/2006, Luke Lonergan wrote:
>Mark,
>
>On 2/24/06 10:10 PM, "Mark Kirkwood" <markir@paradise.net.nz> wrote:
>
> > Well, since this is always fun (2G memory, 3Ware 7506, 4xPATA), writing:
> >
> > $ dd if=/dev/zero of=/data0/dump/bigfile bs=8k count=500000
> > 500000 records in
> > 500000 records out
> > 4096000000 bytes transferred in 32.619208 secs (125570185 bytes/sec)
>
> > Reading:
> >
> > $ dd of=/dev/null if=/data0/dump/bigfile bs=8k count=500000
> > 500000 records in
> > 500000 records out
> > 4096000000 bytes transferred in 24.067298 secs (170189442 bytes/sec)
>
>Not bad at all!  I have one of these cards in my home machine running WinXP
>and it's not nearly this fast.
>
> > Hmmm - a bit humbled by Luke's machinery :-), however, mine is probably
> > competitive on (MB/s)/$....
>
>Not sure - the machines I cite are about $10K each.  The machine you tested
>was probably about $1500 a few years ago (my guess), and with a 5:1 ratio in
>speed versus about a 6:1 ratio in price, we're not too far off in MB/s/$
>after all :-)
>
> > It would be interesting to see what Dan's system would do on a purely
> > sequential workload - as 40-50MB of purely random IO is high.
>
>Yeah - that is really high if the I/O is really random.  I'd normally expect
>maybe 500-600 iops / second and if each IO is 8KB, that would be 4MB/s.  The
>I/O is probably not really completely random, or it's random over cachable
>bits of the occupied disk area.
Side note: the new WD 150GB Raptors (10Krpm 1.5Gbps SATA w/ NCQ
support) have benched at ~1000 IOps _per drive_

http://www.storagereview.com/articles/200601/WD1500ADFD_4.html

(Now if we can just get WD to make a 300GB Raptor, increase that
wimpy 16MB buffer, and implement 6Gbps SATA...;-) )

An array of these things plugged into a PCI-E <-> SATA RAID
controller with 1-2GB of cache should set a new bar for performance
as well as making that performance more resilient than ever to
variations in usage patterns.





pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: Reliability recommendations
Next
From: "Luke Lonergan"
Date:
Subject: Re: Reliability recommendations