DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About Privacy
Sign up
Topics
Follow your own topics →
Menu
New Following Discover Jobs Top Writers
More
Suggest a blog Upvotes plugin Report bug Contact About
Sign up
Privacy Policy
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join Diff.blog
TOPICS

Postgres 19 Compression: from pglz to LZ4

· Crunchy Data · July 16, 2026, 5:53 p.m.
Production Postgres data-compression postgresql lz4 pglz
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
PostgreSQL, Blog engineering
Getting rid of a 4 TB table in PostgreSQL
Radim Marek · Oct 31, 2026
data engineering postgresql
Navicat 18 Review: Is It Worth It for PostgreSQL? Tested on 10M Rows
Aleksei Aleinikov · Nov 2, 2026
navicat navicat-review
Enums Can Be Enforced at the Database Level in PostgreSQL
Nelson Figueroa · Oct 29, 2026
software development postgresql
Managed Postgres: What Lakebase Actually Takes Off Your Plate
Mooncake · Sep 15, 2026
Data + AI Foundations postgresql
Inserting State Transitions in Postgres
Thoughtbot · Aug 24, 2026
postgresql Data Integrity
Discover more posts →
AUTHOR
BLOG POST FEATURED ON

Placeholder image
r/programmer

1 points

Add this plugin to your blog
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub Continue with Google
By continuing, you agree to our Privacy Policy.