LodeHQ
AI news for people who shipFree, by email

Data · crunchydata.com · Monday, 20 July 2026

Postgres 19 Makes LZ4 the New Default for TOAST Compression

PostgreSQL 19 will replace the legacy pglz algorithm with LZ4 as the default TOAST compression method. The change keeps the single compression framework across heap tables, TOAST, and B‑tree indexes, giving better compression ratios and faster CPU performance for TEXT, VARCHAR, BYTEA, JSONB, and other variable‑length columns.

Read the source: crunchydata.com ↗In the 20 July issue →