<ul><li>The author decided to run some tests comparing the performance of ext4 and ZFS in PostgreSQL environments.</li><li>The testing was done on a t3.medium instance with two 20GB gp3 disks, one using an ext4 filesystem and the other one for ZFS.</li><li>ZFS is not available by default in the Debian repositories, so some extra steps are needed like adding the backports repository and installing kernel sources before ZFS install.</li><li>Once ZFS is installed the kernel modules become available and can be loaded using modprobe command.</li><li>The author initialized PostgreSQL for the ext4 filesystem by enabling data checksums, this step is not required for the ZFS filestem as ZFS is doing this anyway.</li><li>The author changed two bits for the ZFS instance, turning off full_page_writes and wal_init_zero which is not required on ZFS.</li><li>Ready to start both clusters by pg_ctl commands.</li><li>Now the author is ready to start with the tests.</li><li>Stay tuned for the results in the next post.</li></ul>

PostgreSQL: Maybe we should give ZFS a chance (1) – baseline

Discover more