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

Поиск
Список
Период
Сортировка
От Michael March
Тема Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Дата
Msg-id AANLkTi=uNPBFeo5OOmp4Z5TPQms83hs=qYcQA_-4typs@mail.gmail.com
обсуждение исходный текст
Ответ на Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Michael March <mmarch@gmail.com>)
Список pgsql-performance
Дерево обсуждения
As a postscript to these tests.. I just tried the 500GB Monentus XT hybrid SSD/HDD drive. I had this fantasy that it would at least do better than the 7200 rpm desktop drive. 

Oh lord, my gut was wrong.  The performance was inconsistent and never over 2/3rds the performance of the slowest desktop drive. 

On Sat, Aug 7, 2010 at 4:47 PM, Michael March <mmarch@gmail.com> 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!




--
<admiral>

Michael F. March ----- mmarch@gmail.com

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

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Very bad plan when using VIEW and IN (SELECT...*)