Re: RAID + PostgreSQL?

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: RAID + PostgreSQL?
Дата
Msg-id e8jrhv$1t4m$1@news.hub.org
обсуждение исходный текст
Ответ на Re: RAID + PostgreSQL?  ("Alex Turner" <armtuk@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Granting COPY FROM access
Следующее
От: "Jim Cser"
Дата:
Сообщение: Granting COPY FROM access