The home for great developer writing.

We surface the best developer writing from thousands of independent blogs, updated daily.

Postgres 19 Compression: from pglz to LZ4

· Crunchy Data · July 16, 2026, 5:53 p.m.

Production Postgres postgresql Database Management data-compression lz4

Summary

This blog post discusses the changes in Postgres 19 regarding its compression algorithm switch from pglz to LZ4, highlighting the impacts on compression decision paths, storage strategies, and real-world index-size limitations.

Read full post on www.crunchydata.com →

MORE POSTS LIKE THIS

Optimizing PostgreSQL Performance & Compression: pglz vs. LZ4

Timescale · Nov 25, 2024

engineering PostgreSQL, Blog

Read your own writes, off the primary

Radim Marek · Aug 31, 2026

Database Management postgresql

Inserting State Transitions in Postgres

Thoughtbot · Aug 24, 2026

postgresql Database Management

Postgres 19: How Our Advice Has Changed Since We Wrote It

Crunchy Data · Aug 18, 2026

Production Postgres Postgres 19

azure: [Launched] Generally Available: Pre-upgrade validation checks for Azure Database for PostgreSQL Flexible Server

Sujith Quintelier · Aug 14, 2026

Azure postgresql

A deep dive into Kysely

Flaviocopes · Aug 11, 2026

Kysely postgresql

Discover more posts →

AUTHOR

Sponsored

Zulip

Organized team chat for people who take work seriously. Topic-based threading keeps conversations focused.

Become a sponsor →

BLOG POST FEATURED ON

Placeholder image

Add this plugin to your blog