From: | "Graeme B(dot) Bell" <grb(at)skogoglandskap(dot)no> |
---|---|
To: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Need more IOPS? This should get you drooling... (5xnvme drives) |
Date: | 2015-06-04 11:07:39 |
Message-ID: | C18341F8-B7C0-49E7-B160-4B49D20FAF35@skogoglandskap.no |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I previously mentioned on the list that nvme drives are going to be a very big thing this year for DB performance.
This video shows what happens if you get an 'enthusiast'-class motherboard and 5 of the 400GB intel 750 drives.
https://www.youtube.com/watch?v=-hE8Vg1qPSw
Total transfer speed: 10.3 GB/second.
Total IOPS: 2 million (!)
+ nice power loss protection (Intel)
+ lower latency too - about 20ms vs 100ms for SATA3 (http://www.anandtech.com/show/7843/testing-sata-express-with-asus/4)
+ substantially lower CPU use per I/O (http://www.anandtech.com/show/8104/intel-ssd-dc-p3700-review-the-pcie-ssd-transition-begins-with-nvme/5)
You're probably wondering 'how much' though?
$400 per drive! Peanuts.
Assuming for the moment you're working in RAID0 or with tablespaces, and just want raw speed:
$2400 total for 2 TB of storage, including a good quality motherboard, with 2 million battery backed IOPS and 10GB/second bulk transfers.
These drives are going to utterly wreck the profit margins on high-end DB hardware.
Graeme Bell
p.s. No, I don't have shares in Intel, but maybe I should...
From | Date | Subject | |
---|---|---|---|
Next Message | Graeme B. Bell | 2015-06-04 11:23:50 | Re: Need more IOPS? This should get you drooling... (5xnvme drives) |
Previous Message | Mark Kirkwood | 2015-06-04 01:19:44 | Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) |