Re: Reliability recommendations - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Reliability recommendations
Date
Msg-id 43FFB067.2070406@paradise.net.nz
Whole thread Raw
In response to Re: Reliability recommendations  (Dan Gorman <dgorman@hi5.com>)
List pgsql-performance
Dan Gorman wrote:
> All,
>
> Was that sequential reads? If so, yeah you'll get 110MB/s? How big  was
> the datafile size? 8MB? Yeah, you'll get 110MB/s. 2GB? No, they  can't
> sustain that. There are so many details missing from this test  that
> it's hard to have any context around it :)
>

Actually they can. Datafile size was 8G, machine had 2G RAM (i.e.
datafile 4 times memory). The test was for a sequential read with 8K
blocks. I believe this is precisely the type of test that the previous
posters were referring to - while clearly, its not a real-world measure,
we are comparing like to like, and as such terrible results on such a
simple test are indicative of something 'not right'.

regards

Mark

P.s. FWIW - I'm quoting a test from a few years ago - the (same) machine
now has 4 RAID0 ata disks and does 175MB/s on the same test....




pgsql-performance by date:

Previous
From: Dan Gorman
Date:
Subject: Re: Reliability recommendations
Next
From: Bruce Momjian
Date:
Subject: Re: