From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: RAID + PostgreSQL? |
Date: | 2006-07-06 20:24:43 |
Message-ID: | e8jrhv$1t4m$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Cser | 2006-07-06 20:30:21 | Granting COPY FROM access |
Previous Message | Scott Marlowe | 2006-07-06 20:18:11 | Re: Granting COPY FROM access |