Re: New Opteron box, dedicated to PostgreSQL

On Mar 18, 2007, at 7:51 AM, Axel Rau wrote:

> This box will have an Areca ARC-1261ML (RAID 1 for OS
and WAL, RAID  
> 0 with 7xRAID1 for pg_data).
> Any hints beside the usual partition alignment and
stripe size of  
> 128kB ?
> Do you use ufs2 with softupdates?

You don't value your data?  Why not RAID10?

I use UFS2 with softupdates.  I generally use the default
RAID stripe  
sizes. Postgres works in 8k pages, so if you have a lot of
locality  
in your db reference, larger stripes might help.  I don't
know.

_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

On Mar 19, 2007, at 11:38 AM, Vivek Khera wrote:

> You don't value your data?  Why not RAID10?

eek  never mind... re-read your message and saw that is what
you're  
doing...

_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"