Re: RAID Controller (HP P400) beat by SW-RAID?

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: RAID Controller (HP P400) beat by SW-RAID?
Дата
Msg-id 201109111912.17064.ahodgson@simkin.ca
обсуждение исходный текст
Ответ на RAID Controller (HP P400) beat by SW-RAID?  (Anthony Presley <anthony@resolution.com>)
Ответы Re: RAID Controller (HP P400) beat by SW-RAID?  (Anthony Presley <anthony@resolution.com>)
Список pgsql-performance
On September 11, 2011 03:44:34 PM Anthony Presley wrote:
> First thing I noticed is that it takes the same amount of time to load the
> db (about 40 minutes) on the new hardware as the old hardware.  I was
> really hoping with the faster, additional drives and a hardware RAID
> controller, that this would be faster.  The database is only about 9GB
> with pg_dump (about 28GB with indexes).

Loading the DB is going to be CPU-bound (on a single) core, unless your disks
really suck, which they don't. Most of the time will be spent building
indexes.

I don't know offhand why the queries are slower, though, unless you're not
getting as much cached before testing as on the older box.

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Postgres for a "data warehouse", 5-10 TB
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: RAID Controller (HP P400) beat by SW-RAID?