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

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

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