TLDR Tech / Data
Postgres 19 Compression: from pglz to LZ4
Postgres 19 plans to switch default TOAST compression from pglz to LZ4, while keeping the same unified compression framework across heap storage, TOAST, and B-tree indexes. Variable-length types like TEXT, VARCHAR, BYTEA, and JSONB are compressed automatically via varlena metadata, with rows targeting ~2 KB before spilling out-of-line to TOAST. LZ4 is much faster than pglz in tests, often compresses better, and still fails fast on incompressible data.
Read the full story