#
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
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
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
.