Re: RAID + PostgreSQL? - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: RAID + PostgreSQL?
Date
Msg-id e8jrhv$1t4m$1@news.hub.org
Whole thread Raw
In response to Re: RAID + PostgreSQL?  ("Alex Turner" <armtuk@gmail.com>)
List pgsql-general
Alex Turner wrote:

> As an aside note, I would consider a 13 disk RAID 5 a high risk
> solution.  If you loose just two drives of 13 at the same time, your
> data is all gone.  If you loose one drive, your array goes into degraded
> mode and your read and write performance goes to hell, and your machine

Well we have a hot standby disk.

> Second thing might be to post an explain analyze so that we can have a
> look at the query and see what's up.  May be some of the tunning gurus
> can give good hints on things missing, like indexes and analyzingness,
> or general query structure.

Oh it is using indexes, but it is still painfully slow.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Granting COPY FROM access
Next
From: "Jim Cser"
Date:
Subject: Granting COPY FROM access