From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Latest advice on SSD?
Date: Wed, 11 Apr 2018 10:56:44 +1200
Message-ID: <25749ee2-40cf-b189-4b6c-dfcee5ebc4ad@catalyst.net.nz> (raw)
In-Reply-To: <CAFwQ8rcCSiD2jC1JXHEh4fjxjzP+M9gGnbBNHj_+rm=Ng2ea+A@mail.gmail.com>
References: <CAFwQ8rcCSiD2jC1JXHEh4fjxjzP+M9gGnbBNHj_+rm=Ng2ea+A@mail.gmail.com>
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!
> Craig
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, pgsql-performance@lists.postgresql.org
Subject: Re: Latest advice on SSD?
In-Reply-To: <25749ee2-40cf-b189-4b6c-dfcee5ebc4ad@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox