Postgres Weekly Issue 620: October 16, 2025

#620 — October 16, 2025

Together with

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)

🌆 The EDB Team also recapped the main threads of PGConf NYC.

IN BRIEF:

JetBrains has released the results of its latest State of Developer Ecosystem Report (above) and Postgres has pushed past MySQL for the first time ever to become the most popular database system in the JetBrains ecosystem.
Often credited with pioneering the Postgres cloud platform/service concept, Heroku has teased the 'next generation' of Heroku Postgres, taking it to an even higher scale.
🇨🇿 Prague PostgreSQL Developer Day 2026 takes place next January 27-28 in Czechia. If you'd like to speak, its Call for Proposals is open until November 14.
Microsoft's Azure team has shared a September 2025 roundup of what's new with Azure Database for PostgreSQL.
A cute example of solving a logic puzzle with Postgres and SQL.

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)

📄 From Text to Token: How Tokenization Pipelines Work James Blackwood-Sewell

📄 Understanding and Setting Postgres JDBC Fetch Size Shane Borden

RELEASES AND CODE:

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

BemiDB 1.7 – Open-source Snowflake and Fivetran alternative bundled together.
ParadeDB 0.19 – Transactional Elasticsearch alternative built on Postgres.
PgDog 0.1.10 – Horizontal scaling for Postgres with automatic sharding.