Re: Hardware recommendations

Поиск
Список
Период
Сортировка
От Andy
Тема Re: Hardware recommendations
Дата
Msg-id 867132.21532.qm@web111310.mail.gq1.yahoo.com
обсуждение исходный текст
Ответ на Re: Hardware recommendations  (Arjen van der Meijden <acmmailing@tweakers.net>)
Список pgsql-performance
> The "common knowledge" you based that comment on, may
> actually not be very up-to-date anymore. Current
> consumer-grade SSD's can achieve up to 200MB/sec when
> writing sequentially and they can probably do that a lot
> more consistent than a hard disk.
>
> Have a look here: http://www.anandtech.com/show/2829/21
> The sequential writes-graphs consistently put several SSD's
> at twice the performance of the VelociRaptor 300GB 10k rpm
> disk and that's a test from over a year old, current SSD's
> have increased in performance, whereas I'm not so sure there
> was much improvement in platter based disks lately?

The sequential IO performance of SSD may be twice faster than HDD, but the random IO performance of SSD is at least an
orderof magnitude faster. I'd think it'd make more sense to take advantage of SSD's greatest strength, which is random
IO.

The same website you linked, anandtech, also benchmarked various configurations of utilizing SSD:
http://www.anandtech.com/show/2739/11

According to their benchmarks putting logs on SSD results in no performance improvements, while putting data on SSD
leadsto massive improvement.  

They used MySQL for the benchmarks. So perhaps Postgresql is different in this regard?





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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Hardware recommendations
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Hardware recommendations