What are the recommended ZFS tunings for PostgreSQL 11 (with TimescaleDB 1.6 extension) running on striped mirrored vdevs of SATA3 SSDs?
I am considering:
But am unsure about the following:
Data compression is pretty important, so I am thinking of keeping the default setting of
recordsize=128K instead of changing it to
8K which will likely cause data compression to be much less effective.
Any advice greatly appreciated!