3 ms·
If you’re asking this question, you should probably be using RDS or another hosted Postgres service. Personally prefer to operate Postgres on ZFS pools. This o
by Cieplak 8y ago
If you’re asking this question, you should probably be using RDS or another hosted Postgres service.
Personally prefer to operate Postgres on ZFS pools. This offers checksumming (integrity), filesystem-level compression (reduced IO hence faster reads), nvm-e ZIL (faster writes). ZFS also supports snapshotting, so if you run the database in a jail, you can snapshot the entire jail, send it over the network, and start it on another host in exactly the state it was snapshotted.