Is it worth it making a ZFS partition with compression for Postgres in order to save space? I assume since it's mostly text it should compress fairly well.
Or is there a better FS for compression?

@matrix@gameliberty.club Don't do FS compression at all for a Postgresql server. You'll mess up your performance.

@solarsailor
I have 3 3900X threads. I don't think it should handle it ok.

@matrix@gameliberty.club It's not about CPU usage, it's about write latency. PostgreSQL and other in memory DBs really really really want to have writes that commit to disk quickly, because they are essentially single threaded while writes are in progress. FS compression increases write latency to the degree that its compression is effective - a little bit for LZO, a lot for GZip. The whole reason Intel created NVDIMMs was to reduce database I/O latency, for example.

@solarsailor @matrix this is why zstd is kinda the best for something like this
@matrix @solarsailor eh, no. LZO-RLE if it supports it. Faster and slightly higher compression.
Sign in to participate in the conversation
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.