We’re launching Lyria 3.5 in Google Flow Music, with advances across musicality, lyrics, vocals, and creative control
deepmind.google·6d ago
AI Engineering
Lobsters·15d ago·5 min read
Postgres 19 Compression: from pglz to LZ4
TL;DR
Postgres 19 will transition its default TOAST compression from pglz to LZ4, enhancing data storage efficiency. This change aims to improve performance for variable-length data types like TEXT and JSONB.
✦ Why It Matters
Engineers should consider migrating to Postgres 19 to take advantage of improved data compression and performance benefits.
Key Takeaways
- Test LZ4 compression in your Postgres environment today.
- Monitor performance metrics during data insertion and retrieval.
- Evaluate compression ratios for different data types.
- Stay updated on future Postgres releases for further enhancements.
How It Works
Postgres uses a unified compression framework for table storage and indexes, automatically compressing variable-length types. LZ4's 64 kB sliding window allows it to efficiently find back-references in data, improving compression ratios and speeds compared to pglz.