Re: Hardware recommendations - Mailing list pgsql-performance

From Andy
Subject Re: Hardware recommendations
Date
Msg-id 867132.21532.qm@web111310.mail.gq1.yahoo.com
Whole thread Raw
In response to Re: Hardware recommendations  (Arjen van der Meijden <acmmailing@tweakers.net>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Hardware recommendations
Next
From: Greg Smith
Date:
Subject: Re: Hardware recommendations