RAID + PostgreSQL?

From: "MG" <pgsql-general(at)carladata(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RAID + PostgreSQL?
Date: 2006-06-26 07:36:52
Message-ID: 006e01c698f3$4b25a130$340aa8c0@geisslinger
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Baguette 2006-06-26 07:43:43 Re: "Ghost" colmumn with primary key
Previous Message Joseph Shraibman 2006-06-26 03:49:04 Re: Idea for vacuuming