4 ms·
Also, any kind of workload that involves a sync for durability and correctness. In enterprise drives the drive can return quickly even if it's in the buffer be
by mtanski 10y ago
Also, any kind of workload that involves a sync for durability and correctness.
In enterprise drives the drive can return quickly even if it's in the buffer because there's enough charge in the capacitor to whiteout to NAND from RAM in the event of power failure (hard reboot or power loss).
The consumer drive absent the capacitor either has poor fsync performance or lies about syncs.
There are people who run consumer drives in data centers due to the low GB/$ cost of them or they have applications that are not sensitive for data loss or were engineered to deal with it (replication, journaling, etc..). You won't want to run your important database on such a drive.
- olavgg 10y agoThis is absolutely true, you can for example run pg_test_fsync to test your fsync performance. On Ubuntu, if you have installed PostgreSQL this is available at /usr/lib/postgresql/9.5/bin/pg_test_fsync I get 4000 IOPS on my old Intel 320, which beats the crap out of most "top" performers on the consumer side today.