Horton

Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mario Weilguni <mweilguni@sime.com>
Cc: "Bjoern Metzdorf" <bm@turtle-entertainment.de>, "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-performance@postgresql.org
Date: 2002-11-22T13:52:48Z
Lists: pgsql-performance 
Mario Weilguni <mweilguni@sime.com> writes:
> If 4 drives are an option, I suggest 2 x RAID1, one for data, and one for WAL and temporary DB space (pg_temp).

Ideally there should be *nothing* on the WAL drive except WAL; you don't
ever want that disk head seeking away from the WAL.  Put the temp files
on the data disk.

			regards, tom lane