Re: Performance while loading data and indexing

Поиск
Список
Период
Сортировка
От Mats Lofkvist
Тема Re: Performance while loading data and indexing
Дата
Msg-id y2qwup71zde.fsf@algonet.se
обсуждение исходный текст
Ответ на Performance while loading data and indexing  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: Performance while loading data and indexing  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
shridhar_daithankar@persistent.co.in ("Shridhar Daithankar") writes:

[snip]
>
> Couple MB of data per sec. to disk is just not saturating it. It's a RAID 5
> setup..
>

RAID5 is not the best for performance, especially write performance.
If it is software RAID it is even worse :-).

(Note also that you need to check that you are not saturating the
number of seeks the disks can handle, not just the bandwith.)

Striping should be better (combined with mirroring if you need the
safety, but with both striping and mirroring you may need multiple
SCSI channels).

      _
Mats Lofkvist
mal@algonet.se

В списке pgsql-general по дате отправления:

Предыдущее
От: Mats Lofkvist
Дата:
Сообщение: Re: [HACKERS] Performance while loading data and indexing
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: [JDBC] Prepared statement performance...