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

philip johnson <philip.johnson@atempo.com>

From: "philip johnson" <philip.johnson@atempo.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-performance@postgresql.org>
Date: 2002-11-22T14:17:26Z
Lists: pgsql-performance
pgsql-performance-owner@postgresql.org wrote:
> Objet : Re: [PERFORM] [ADMIN] H/W RAID 5 on slower disks versus no
> raid on
> 
> 
> 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
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Don't 'kill -9' the
> postmaster 

which temp files ?