3 ms·
Also, compression. CPUs are more than capable of handling it on the fly, and the reduced dataset size helps IO. This [0] is a brief post on MySQL, but most of
by sgarland 3y ago
Also, compression. CPUs are more than capable of handling it on the fly, and the reduced dataset size helps IO.
This [0] is a brief post on MySQL, but most of it applies equally to Postgres.
[0]: https://www.percona.com/blog/mysql-zfs-performance-update/ https://www.percona.com/blog/mysql-zfs-performance-update/
- doublepg23 3y agoI'd be curious if the addition of zstd compression has any effect on the results. Could be a fun follow-up follow-up :-)