Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

Поиск
Список
Период
Сортировка
От Scott Carey
Тема Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Дата
Msg-id BAE01AAD-6C69-48C7-BD2E-77E463D49903@richrelevance.com
обсуждение исходный текст
Ответ на Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Michael March <mmarch@gmail.com>)
Ответы Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Michael March <mmarch@gmail.com>)
Список pgsql-performance
Дерево обсуждения
SSD's actually vary quite a bit with typical postgres benchmark workloads.  Many of them also do not guarantee data that has been sync'd will not be lost if power fails (most hard drives with a sane OS and file system do).


On Aug 7, 2010, at 4:47 PM, Michael March wrote:

If anyone is interested I just completed a series of benchmarks of stock Postgresql running on a normal HDD vs a SSD.  

If you don't want to read the post, the summary is that SSDs are 5 to 7 times faster than a 7200RPM HDD drive under a pgbench load.


Is this what everyone else is seeing?

Thanks!


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

Предыдущее
От: Michael March
Дата:
Сообщение: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Следующее
От: Scott Carey
Дата:
Сообщение: Re: Advice configuring ServeRAID 8k for performance