#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Sign up
The home for great developer writing.
Discover the best posts from developers and engineering teams, all in one place.
Join now
→
Learn more
TOPICS
Postgres 19 Compression: from pglz to LZ4
30
·
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
PostgreSQL, Blog
engineering
VACUUM at the Page Level
Radim Marek ·
Jul 5, 2026
postgresql
vacuum
How to Schedule Jobs in PostgreSQL with pg_cron
freeCodeCamp.org ·
Jun 17, 2026
postgresql
cronjob
Integrate OpenShift AI and PG Airman MCP Server
Red Hat ·
Jun 9, 2026
OpenShift AI
postgresql
Foreign Data Wrapper: Postgresify all the things!
Marmelab ·
Jun 3, 2026
Postgres
postgresql
Postgres Serials Should be BIGINT (and How to Migrate)
Crunchy Data ·
Jan 20, 2026
Production Postgres
postgresql
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