Date: Mon, 19 Mar 2007 11:38:56 -0400 From: Vivek Khera <vivek@khera.org> To: freebsd-database@freebsd.org Cc: FreeBSD AMD list <freebsd-amd64@freebsd.org> Subject: Re: New Opteron box, dedicated to PostgreSQL Message-ID: <CBF10BDF-C0D4-4D40-9F35-B9F8CF89D96B@khera.org> In-Reply-To: <7489C7AA-BD33-4144-ABD4-73338CD5C7C7@Chaos1.DE> References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> <b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com> <111EFCD1-0B88-4646-BCF5-B13D1F3BBCB0@khera.org> <7489C7AA-BD33-4144-ABD4-73338CD5C7C7@Chaos1.DE>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CBF10BDF-C0D4-4D40-9F35-B9F8CF89D96B>