3 ms·
I can see that the author put some considerable time into testing and writing the article, but nobody in the business of deploying production Posgresql should e
by dboreham 11y ago
I can see that the author put some considerable time into testing and writing the article, but nobody in the business of deploying production Posgresql should ever have been using the various models of desktop SSD that were tested. This is because the subject of which SSD are reliable has come up repeatedly on the PG mailing lists. Several heavy PG users and developers have already done testing and the universally accepted advice in that forum, for years, has been to never ever use a drive that lacks power fail protection.
Disclosure: we run Postgresql in production on Intel and Samsung "data center grade" SSDs, and I participated in the aforementioned PG mailing list discussions.
Updated: from http://www.postgresql.org/docs/9.4/static/wal-reliability.html http://www.postgresql.org/docs/9.4/static/wal-reliability.ht...
"Many solid-state drives (SSD) also have volatile write-back caches."
and this thread:
http://www.postgresql.org/message-id/533F405F.2050106@benjamindsmith.com http://www.postgresql.org/message-id/533F405F.2050106@benjam...
and
https://news.ycombinator.com/item?id=6973179 https://news.ycombinator.com/item?id=6973179
- kustodian 11y ago"...but nobody in the business of deploying production Posgresql should ever have been using the various models of desktop SSD that were tested." this is one of the reasons why this article was written. To show you how to test, to see what you should use and what you shouldn't in production. When we did these tests we already knew we shouldn't use those SSDs, we mostly did it just for the sake of testing, to see if the tests we wanted to use make any sense and to show others how to do it. Also I know it may sound funny to use these SSDs in production, but when we started with our game Top Eleven we didn't know that, when you have 5 people working on a game, you don't have time (nor resources) to think about a type of an SSD; you order server with an SSD, you get an SSD (you usually don't even have a choice when you rent) and you use it. This is how it still works with almost any server renting company.
- dboreham 11y agoOk, you didn't know something that's common knowledge in the industry - that's reasonable. I'm sure there are plenty of things I don't know that I should. But there are only three people in our company and we spend quite a bit of time worrying about SSD reliability because our business depends on it :)