| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Advice configuring ServeRAID 8k for performance |
| Date: | 2010-08-05 23:58:13 |
| Message-ID: | 201008051658.13399@hal.medialogik.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thursday, August 05, 2010, Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
wrote:
> Normally I'd agree with the others and recommend RAID10 - but you say
> you have an OLAP workload - if it is *heavily* read biased you may get
> better performance with RAID5 (more effective disks to read from).
> Having said that, your sequential read performance right now is pretty
> low (151 MB/s - should be double this), which may point to an issue
> with this controller. Unfortunately this *may* be important for an OLAP
> workload (seq scans of big tables).
Probably a low (default) readahead limitation. ext3 doesn't help but it can
usually get up over 400MB/sec. Doubt it's the controller.
--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2010-08-06 00:31:50 | Re: Advice configuring ServeRAID 8k for performance |
| Previous Message | Mark Kirkwood | 2010-08-05 23:32:28 | Re: Advice configuring ServeRAID 8k for performance |