Re: New Opteron box, dedicated to PostgreSQL
Vivek Khera <[email protected]> Mon, 19 Mar 2007 11:38:56 -0400
| Newsgroups | gmane.os.freebsd.devel.amd64,gmane.os.freebsd.devel.database |
|---|---|
| Message-ID | <[email protected]> |
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.