Re: WAL in RAM

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.