Postgres Weekly Issue 610: July 31, 2025

#610 — July 31, 2025

Together with

Making Postgres 42,000x Slower (Because I Am Unemployed) — We run a lot of items on getting the most out of Postgres and making things run as quickly and smoothly as possible, but could you learn something by going the other way in an attempt to make Postgres as slow as possible? A seemingly pointless exercise, but a good way to learn about what some of Postgres’s configuration options actually do.

Jacob Jackson

💡 If you'd prefer something more directly usable, Jacob has also written a quick(ish) introduction to tuning Postgres.

Speed Up Postgres Queries With pganalyze Query Advisor — See how our new Query Advisor feature detected plan issues and sped up a Postgres query by over 1000x. Watch the webinar on demand to learn how to spot inefficient queries, get rewrite recommendations, & track improvements.

pganalyze sponsor

IN BRIEF:

📊 The Stack Overflow 2025 survey results are out and it's good news for Postgres sitting at the number one spot for most used database, though MySQL takes the lead for learners.
The EDB blog shares the tales of Bruce Momjian's latest movements speaking about Postgres all around the world.
Polina Bungina is this week's PostgreSQL Person of the Week interviewee.
🤖 Postgres AI is working on an open source 'Self-Driving Postgres' project.

Sharding Postgres at Network Speed — The lead developer of the PgDog transaction pooler / Postgres sharding tool shares the technical details of PgDog’s new, high speed logical replication based re-sharding feature.

Lev Kokotov

📄 Why Postgres Needs Better Connection Security Defaults – Understanding the difference between sslmode=require and sslmode=verify-full is essential. George MacKerron (Neon)

📄 How CERN Powers Ground-Breaking Physics with TimescaleDB – A case study, but with some interesting technical tidbits from the heart of Europe’s science industry. TigerData

📄 Migration and Upgrades: Achieving Near Zero-Downtime in Postgres Sebastian Insausti

📄 Postgres CDC to Iceberg: Lessons from Real-World Data Pipelines Yingjun Wu (RisingWave)

📰 Classifieds

🐘 Atlas manages Postgres like Terraform manages infra. Define schema as code and safely plan and apply migrations. Find out more.

💌 Did you know we have a whole family of newsletters? Check out JavaScript Weekly, Go Weekly and Ruby Weekly for a broader look at what we do.

RELEASES:

pg_meminfo: Postgres Memory Usage Stats for Linux — A Linux-only extension to inspect detailed per-backend memory usage using simple SQL queries. It surfaces metrics like pss for each backend process, making it easier to diagnose memory issues or investigate leaks. Shaun also suggests the code could be useful as a learning exercise for others looking to build similar extensions.

Shaun Thomas

pgsql-http 1.7: An HTTP Client for Postgres — “Wouldn’t it be nice to be able to write a trigger that called a web service? Either to get back a result, or to poke that service into refreshing itself against the new state of the database?”

Paul Ramsey

Mathesar 0.4 – A spreadsheet-like interface for Postgres tables.
DbGate 6.6 – Database manager app for both SQL and NoSQL databases.
Supavisor 2.6 – Supabase's multi-tenant Postgres connection pooler.
RisingWave 2.5 – Postgres-compatible streaming database.
Bob 0.39 – SQL query builder and ORM/Factory generator for Go.
Piccolo 1.28 – User-friendly Python ORM and query builder.
Prisma 6.13 – Next-gen Node.js + TypeScript ORM.
pgAdmin 4 v9.6 – Popular Postgres admin tool.