RAID + PostgreSQL? - Mailing list pgsql-general

From MG
Subject RAID + PostgreSQL?
Date
Msg-id 006e01c698f3$4b25a130$340aa8c0@geisslinger
Whole thread Raw
Responses Re: RAID + PostgreSQL?  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Re: RAID + PostgreSQL?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Hello,
 
we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.
 
When we do a big SELECT-query the whole maschine becomes very very very slowly or stands.
The maschine has 3 GB RAM, so we suppose it`s the RAID.
 
Has anyone some experience with RAID + PostgreSQL?
 
Where does PostgreSQL saves his temporary files? Perhaps these are the reason for the bad performance.
 
Greetings
 
Michaela

pgsql-general by date:

Previous
From: Bruno Baguette
Date:
Subject: Re: "Ghost" colmumn with primary key
Next
From: lrotger
Date:
Subject: update impossible, constraint prevents it but it shouldn't