@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.
@sjw @solarsailor lz4 is probably still the fastest though
https://indico.fnal.gov/event/16264/contributions/36466/attachments/22610/28037/Zstd__LZ4.pdf