#​619 — October 9, 2025

Web Version
Together with  Bytebase

Postgres Weekly

Building and Debugging Postgres — How to set up a container for building Postgres from source and then debugging it from GDB and VS Code. Useful tips if you want to start digging around Postgres internals.

Stefanos Baziotis

Exploring Postgres to Parquet Archival for JSON Data with S3 Range Reads — How to move ‘cold’ JSON from Postgres to Parquet on S3 and then be able to fetch it back fast without reading whole files.

Shayon Mukherjee

How to Implement Postgres DevOps and Security — Review, approve, deploy, and enforce query access control. Plus dynamic data masking and audit trails. All-in-one GUI workspace, open-source, trusted by 350+ companies, including Linear and note​.com.

Bytebase sponsor

▶  Hands on Postgres 18: Async I/O, B-Tree Skip Scan, UUIDv7 — The founder of pganalyze presented a webinar digging into some of more noteworthy improvements in Postgres 18. The section on asynchronous I/O (running from 4:20 to 22:30) is particularly useful.

Lukas Fittl

IN BRIEF:

On Developing OAuth Support for Postgres — One of the first champions for OAuth support in Postgres (explored in a practical sense here) tells the tale of how it came to be in Postgres 18, why it’s exciting, and what’s yet to come.

Jacob Champion

📄 Ratcheting with Postgres CONSTRAINT – A way to enforce constraints (e.g. ‘NOT NULL’) for future queries without having to immediately enforce them table-wide. Andrew Judson

📄 Postgres Migrations Using Logical Replication Elizabeth Christensen

📄 IBM Invites CockroachDB to Infest Its Mainframes with 'PostgreSQL' – A typically quirky headline for The Register! The real story is IBM is looking to offer a Postgres-like database on its mainframe hardware. The Register

📄 SkipScan in TimescaleDB: Why DISTINCT Was Slow, How We Built It, and How You Can Use It Aksman and Hein (TigerData)

📄 Key Operational Enhancements and Integration Options in Postgres 16 Sebastian Insausti

RELEASES:

pgwatch 4.0: A Flexible Postgres Monitoring Solution — Provides a user-friendly interface through Grafana dashboards, letting you inspect various metrics (health, performance, index usage, I/O, etc.) and trends. v4.0 introduces a variety of enhancements and drops Grafana v10 support.

CYBERTEC

pg_statement_rollback v1.5: Server Side Rollback at Statement Level — Add server side transaction rollback at statement level, like in Oracle or Db2. This version adds Postgres 18 support.

Hexacluster

  • PostgreSQL R2DBC Driver 1.1 – Bringing reactive APIs to relational databases in the Java world.

  • QuestDB 9.1 – Java-powered time-series database with Postgres wire protocol compatibility.

  • River 0.26 – Fast & reliable Postgres-powered background jobs system for Go.

  • tbls 1.89 – Auto document a database in Markdown format, such as in CI.

  • Goose 3.26 – Database migration tool. Supports SQL and Go functions.

  • Mathesar 0.6 – A spreadsheet-like interface for Postgres tables.

  • Barman 3.16 – Backup and disaster recovery tool.