1. 8
  1. 5

    ZFS dataset for PostgreSQL data with 8k record size

    You only need 8k for Serious Production (actually high database load). For personal stuff, especially on VPSes where you pay for storage, you might prefer a large recordsize. Because compression! My Matrix server’s postgres dataset gets 3.02x compression (lz4) thanks to 64k recordsize. Currently 6.98G written, 21.1G logicalused. My whole EBS volume is only 20G! Without good compression, I’d already be paying more money.

    1. 1

      Good point thanks ;)