We have been using the Intel S3710 (or minor model variations thereof). They have been great (consistent performance, power off safe and good expected lifetime). Also 2 of them in RAID1 easily outperform a reasonably large number of 10K spinners in RAID10.
Now you *can* still buy the S37xx series, but eventually I guess we'll have to look at something more modern like the S45xx series. But I'm not so keen on them (they use TLC NAND which may give less consistent performance, plus they appear to have slightly lower expected lifetime). I think there was a thread a year or more ago on this list specifically about this very issue that might be worth searching for.
The TLC NAND seems like a big deal - most modern SSD are built using it...they solve the high latency problem with SLC caches. So you get brilliant performance until the cache is full, then it drops off a cliff. Bigger/more expensive drives have bigger caches, so it is well worth finding in depth reviews of the exact models you might wish to evaluate!
regards
Mark
On 10/04/18 14:36, Craig James wrote:
One of our four "big iron" (spinning disks) servers went belly up today. (Thanks, Postgres and pgbackrest! Easy recovery.) We're planning to move to a cloud service at the end of the year, so bad timing on this. We didn't want to buy any more hardware, but now it looks like we have to.
I followed the discussions about SSD drives when they were first becoming mainstream; at that time, the Intel devices were king. Can anyone recommend what's a good SSD configuration these days? I don't think we want to buy a new server with spinning disks.
We're replacing:
8 core (Intel)
48GB memory
12-drive 7200 RPM 500GB
RAID1 (2 disks, OS and WAL log)
RAID10 (8 disks, postgres data dir)
2 spares
Ubuntu 16.04
Postgres 9.6
The current system peaks at about 7000 TPS from pgbench.
Our system is a mix of non-transactional searching (customers) and transactional data loading (us).
Thanks!