6 ms·
Nice overview, bookmarked. Only thing i could say is missing are some graphs :)
by iRobbery 5y ago
Nice overview, bookmarked. Only thing i could say is missing are some graphs :)
- hardwaresofton 5y agoThanks! I unfortunately wasn't really scientifically disciplined enough as I ran pgbench running through configurations, so I didn't include my notes or numbers but hopefully someday I can come back to this with a fresh wad of cash to spend on dedicated hardware fit for purpose and put some of this to rest! One of the things about this kind of benchmarking/testing is that it really requires multiple days worth of evaluation (index bloat, disk fragmentation, etc) and is really hard to get right... I'm afraid I'd add more noise than signal. Some great resources out there though, like Percona's post on MySQL: https://www.percona.com/blog/mysql-zfs-performance-update/ https://www.percona.com/blog/mysql-zfs-performance-update/ Even in there though, the comments are full of reasonable objections, with some really sage advice in terms of fragmentation and really measuring whether ZFS can coalesce your writes. It's a hard topic!
- R0b0t1 5y agoRun it on really bad hardware, might be easier to see the differences. Could use some of the dm drivers to inject latency on disks too.
- hardwaresofton 5y agoAh thanks for this, I didn't know there was actually a dm driver to inject latency. TIL it's called dm-delay[0][1]. [0]: https://www.kernel.org/doc/html/latest/admin-guide/device-mapper/delay.html https://www.kernel.org/doc/html/latest/admin-guide/device-ma... [1]: https://enodev.fr/posts/emulate-a-slow-block-device-with-dm-delay.html https://enodev.fr/posts/emulate-a-slow-block-device-with-dm-...