#​627 — December 4, 2025

Web Version

🗓️ Every now and then we do a roundup of upcoming Postgres events and 2026 is already shaping up to be a busy year – check it out at the end of the issue.
__
Your editor, Peter Cooper.

Together with  Microsoft logo

Postgres Weekly

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

IN BRIEF:

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

📄 Configuring Postgres Logs: A Practical Guide – Goes into more depth than you might expect. Dash0

📄 Unraveling a Postgres Segfault That Uncovered an Arm64 JIT Compiler Bug Bonnefoy, McGarvey and Ward (Datadog)

RELEASES AND CODE:

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

📰 Classifieds

🌍 From single node to global clusters: run PostgreSQL anywhere. Try pgEdge Enterprise.

🛣️ The Road to Next.js is a course by Robin Wieruch for learning full-stack web development with Next.js 15 and React 19.

  • TimescaleDB 2.24 – Time series capabilities for Postgres in an extension. v2.24 adds 'lightning-fast' recompression and continuous aggregates now fully support UUIDv7.

  • PEV2 v1.19.0 – Vue.js component for visualization of Postgres execution plans.

  • PeerDB 0.36 – Stream data from Postgres to data warehouses, queues and storage engines.

  • Supavisor 2.8 – Supabase's multi-tenant Postgres connection pooler.

  • temBoard 10.0 RC1 – Manage a Postgres fleet from a web interface.

  • PGSync 6.2 – Postgres to Elasticsearch/OpenSearch syncing.

🗓 Upcoming Postgres Events in 2026

Note: This list is not exhaustive, and we will continue to mention and promote other events over time.