3 ms·
Interesting. I've never seen large-scale database deployments use SSDs (neither for the transaction log, nor for the data); I've only seen battery-backup and wr
by rudiger 16y ago
Interesting. I've never seen large-scale database deployments use SSDs (neither for the transaction log, nor for the data); I've only seen battery-backup and write-back caches on hard disk drives used.
- zwischenzug 16y agoNor have I. But it may be the future: cf rethinkdb.
- jpitz 16y agoYou will probably start to. The intel 320 series is getting some attention now [1] with a combination of competitive ( for SSD ) price and enough capacitors on board to flush the write cache on a power failure. You'd likely use SSDs first for indexes, then data. Transaction logs are usually a sequential workload and 7200 rpm drives often suffice. [1] http://archives.postgresql.org/pgsql-performance/2011-03/msg00342.php http://archives.postgresql.org/pgsql-performance/2011-03/msg...