Recent content by olavgg

You are all already using a ramdisk, https://en.wikipedia.org/wiki/Page_cache https://docs.microsoft.com/en-us/windows/desktop/fileio/file-caching

This thread is painful to read, why do people not understand that low latency will significantly increase performance. Optane is like 5000x faster than Samsung 960 Pro when running SQLite benchmarks. You know what applications that use SQLite a lot? Your web browser! And there are like billions...

There are thousands of other reasons that machine will go offline before the SSD will fail. If uptime is important, you need some kind of system redundancy. Mirroring SSDs is still a poor solution.

The Nytro SSD's looks really awesome. Another thing though, enterprise SSD's are so reliable, that mirroring them is in my opinion just a waste of performance/money and time (adds complexity). At ServeTheHome they have some statistics on Intel S3700 drives where almost noone ever failed. In...

Optane, because it will act as additional system memory. With Optane you need less expensive RAM. Especially consumer level SSD's are just slightly faster than 10k spinners. Every real benchmark where you check latency and write sync/flush they are just horrible. In these benchmarks, Optane is...

Actually it is very easy to prove this. You can use fio, dd or pg_test_fsync For example $ sudo fio --filename=/dev/nvme0n1 --direct=1 --sync=1 --rw=write --bs=4k --numjobs=10 --iodepth=1 --runtime=10 --time_based --group_reporting --name=journal-test $ sudo pg_test_fsync -f...

Still the old Intel 320 give me up 8000 iops for the same benchmarks. I would just get a SSD that gives most GB of storage per $. If you need performance, then Samsung 960 NVME does far from cut it. The truth is, most consumer level SSD's perform almost equally bad.

I would not buy Samsung 960 nvme, in my benchmarks for random write I get only 1000 iops, where with Intel 900p Optane I get 500 000 iops. That is a 500x difference!!!

This is quite common among most of the consumer grade SSD's. On Servethehome, all consumer SSD's are marked as pile of shit, crap performance, worthless and so on. On Ebay, enterprise SSD's are available for same $ per gb as consumer SSD's, but for example the Intel S3700 series still have 20x...

If you mean random read, then just get more RAM. That is where you do most of your random reads ;)

You buy enterprise SSD's from Ebay. 90% have been used for a few hours. The price per GB is the same or just slightly above consumer level SSD's

Hardware raid is only faster because it doesn't have to read/write additional io operations to disk drives for each parity block calculated. Modern CPU's with SSE3 or better can do parity calculation for thousands of MB per second. The biggest problem with hardware raid is cost though...

This is a really good answer! People should bookmark this.

Tested with pg_test_fsync and fio on Intel 6700K @ 4.6ghz on Ubuntu 17.04

They are not shit, they are okey! For spinners there is no need to upgrade.