Postgres Pro
Downloads
Home   >   mailing lists

Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From Luke Lonergan
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id 3E37B936B592014B978C4415F90D662D01995FD4@MI8NYCMAIL06.Mi8.com
Whole thread Raw
Responses Re: Hardware/OS recommendations for large databases (  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
Tree view
Dave,

From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Dave Cramer
Sent: Tuesday, November 15, 2005 6:15 AM
To: Luke Lonergan
Cc: Adam Weisberg; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Hardware/OS recommendations for large databases (

Luke,

Have you tried the areca cards, they are slightly faster yet. 
No, I've been curious since I read an earlier posting here.  I've had a lot more experience with the 3Ware cards, mostly good, and they've been doing a lot of volume with Rackable/Yahoo which gives me some more confidence.
 
The new 3Ware 9550SX cards use a PowerPC for checksumming, so their write performance is now up to par with the best cards I believe.  We find that you still need to set Linux readahead to at least 8MB (blockdev --setra) to get maximum read performance on them, is that your experience with the Arecas?  We get about 260MB/s read on 8 drives in RAID5 without the readahead tuning and about 400MB/s with it.
 
- Luke

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: "Luke Lonergan"
Date:
Subject: Re: Hardware/OS recommendations for large databases (