Re:We saved millions in SSD costs by upgrading our filesystem
by nwmcsween on Tuesday November 09, 2021 @03:57PM
(#29167374)
What about: https://people.freebsd.org/~seanc/postgresql/scale15x-2017-p...
16k record size 2x amplification and still (?) allows compression w/ lz4
And yes - Postgres will automatically TOAST oversized tuples and compress the relevant data (if you configure it to do so). This is much lower impact for us than filesystem level compression, as it doesn't affect the main relation heap space (or any indexes).