Postgres 19 Compression: from pglz to LZ4

3 months ago by steam_lover to c/postgresql

With Postgres 19 switching the default from pglz to LZ4, this post walks through the compression decision path, storage strategies, and index-size limits that shape real-world behavior.
postgresql
postgresql

@programming.dev

login for more options
2251
203
21

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

go to feed...