Re: Disappointing performance in db migrated from MS SQL

Поиск
Список
Период
Сортировка
От matt@ymogen.net
Тема Re: Disappointing performance in db migrated from MS SQL
Дата
Msg-id 1980.82.68.132.233.1076709614.squirrel@webmail.ymogen.com
обсуждение исходный текст
Ответ на Re: Disappointing performance in db migrated from MS SQL Server  (Leon Out <leon-lists@comvision.com>)
Ответы Re: Disappointing performance in db migrated from MS SQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-performance
Дерево обсуждения 
> Josh, the disks in the new system should be substantially faster than
> the old. Both are Ultra160 SCSI RAID 5 arrays, but the new system has
> 15k RPM disks, as opposed to the 10k RPM disks in the old system.

Spindle speed does not correlate with 'throughput' in any easy way.  What
controllers are you using for these disks?

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

Предыдущее
От: Leon Out
Дата:
Сообщение: Lengthy pg_restore and high iowait?
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Disappointing performance in db migrated from MS SQL Server