New Opteron box, dedicated to PostgreSQL

Vivek Khera vivek at khera.org
Mon Mar 19 15:38:58 UTC 2007


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.



More information about the freebsd-amd64 mailing list