| 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: | Whole Thread | Raw Message | 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 |