#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Privacy
Sign up
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
What REPACK (CONCURRENTLY) costs while it runs
Radim Marek ·
Sep 27, 2026
concurrency
software development
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
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
software development
Discover more posts →
AUTHOR
Advertise
Sponsor diff.blog
Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.
Become a sponsor →
BLOG POST FEATURED ON
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
.