On 10/28/2011 12:26 PM, Tomas Vondra wrote:
For example the Intel 710 SSD has a sequential write speed of 210MB/s,
while a simple SATA 7.2k drive can write about 50-100 MB/s for less than
1/10 of the 710 price.
Bulk data transfer rates mean almost nothing in the context of a database
(unless you're for example backing it up by copying the files to another
machine...)
The key factor typically is small block writes/s (for WAL) and random
small block
reads/s (for data). 710 or similar performance SSDs will deliver on the
order
of 20-50x the performance of a traditional hard drive in these areas.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
