Thomas F. O'Connell wrote:
On Aug 8, 2006, at 4:49 PM, Joshua D. Drake wrote:
I am considering a setup such as this:
- At least dual cpu (possibly with 2 cores each)
- 4GB of RAM
- 2 disk RAID 1 array for root disk
- 4 disk RAID 1+0 array for PGDATA
- 2 disk RAID 1 array for pg_xlog
Does anyone know a vendor that might be able provide such setup?
Wouldn't it be preferable to put WAL on a multi-disk RAID 10 if you had
the opportunity? This gives you the redundancy of RAID 1 but approaches
the performance of RAID 0, especially as you add disks to the array. In
benchmarking, I've seen consistent success with this approach.
WALL is written in order so RAID 1 is usually fine. We also don't need
journaling for WAL so the speed is even faster.
Joshua D. Drake
--
Thomas F. O'Connell
Sitening, LLC
http://www.sitening.com/
3004B Poston Avenue
Nashville, TN 37203-1314
615-469-5150 x802
615-469-5151 (fax)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
