Benchmarking Postgres 17 vs 18 — The author conducted a series of detailed performance benchmarks between Postgres 17 and 18, in some 96 combinations, and reassuringly finds that Postgres 18 gives us a nice performance bump, local disks rule, and tweaking your settings is still worthwhile.

Ben Dicken (PlanetScale)

How note․com Implements Just-in-Time (JIT) Database Access Control — note.​com, the leading C2C creator platform in Japan, replaced an in-house GitHub Actions + SSH proxy flow for ad-hoc Aurora Postgres access with Bytebase’s just-in-time (JIT) access control.

Bytebase sponsor

A Postgres Trip Report from PGConf NYC 2025 — PGConf NYC 2025 took place two weeks ago and was a big success. Claire, well known for her Talking Postgres podcast, spills the tea on what happened at the event and shares lots of great photos too.

Claire Giordano (Microsoft)

Exploring Postgres 18's New UUIDv7 Support — Unlike with UUIDv4, UUIDv7 values are monotonic and time-sortable, which presents some advantages.

Fridriksson and Miller (Aiven)

pqr.sql: Generate QR Codes with Pure SQL in Postgres — A cute idea which probably has some non-obvious use case. Though it does take several hundred lines of SQL to pull off.

Tanel Põder

PGSync 5.0: Postgres to ElasticSearch/OpenSearch Syncing — Middleware that captures changes from your database and writes structured documents to your search cluster. Originally for Postgres only, v5.0 adds MySQL/MariaDB support too. GitHub repo.

Tolu Aina

Sanitizing SQL with SQL — A proof-of-concept PL/pgSQL function that can take raw SQL and return a sanitized version minus any personally identifiable information.

Jeremy Schneider

pg_qualstats: Extension for Collecting Statistics About Predicates — Analyze the most often used predicates in queries against your database, perhaps as a way to create the most effective indexes possible. Part of the POWA (Postgres Workload Analyzer) project.

Powa Team