On the Efficient Storage of JSON Data in Postgres — JSON vs JSONB for a data type, pglz vs lz4 for compression.. what combination performs best for the most efficient storage of JSON? Hubert does some investigations to find out how different combinations perform, both in terms of query speed and storage space.

Hubert depesz Lubaczewski

POSETTE 2026: Call for Proposals (CFP) is Open! — POSETTE: An Event for Postgres, a free & virtual developer event organized by the Postgres team at Microsoft, is happening June 16-18. The CFP is open until February 1. New and experienced speakers are encouraged to submit! Get the details.

Microsoft sponsor

Transparent Data Encryption (TDE) Now Available for Postgres 18 — Percona now ships a build of Postgres 18.1 with fully supported native TDE and asynchronous I/O. TDE offers encryption at the file level and solves the problem of protecting data ‘at rest.’

Percona

What is Better: A Lookup Table or an Enum Type? — There are pros and cons both ways and it all depends on your constraints.

Laurenz Albe

ParadeDB 0.20.0: Simpler and Faster Elasticsearch-Quality Full-Text Search — ParadeDB brings Elastic-quality, ACID guaranteed search capabilities and analytical performance to Postgres. v0.20.0 introduces new conjunction and disjunction operators and a simpler approach to creating indexes, plus more performance all round.

Philippe Noël

Psycopg 3.3: The Modern PostgreSQL Adapter for Python — Gains support for Python 3.14’s template strings, opening up a new way to cleanly write dynamic queries that are still bound safely. Official homepage.

Psycopg Development Team