Sammlung von Newsfeeds

Three autovacuum parameters control how often PostgreSQL vacuums, how hard it works, and how long it pauses.

When your database catches fire, panic is optional. Learn seven battle-tested rules that turn chaos into a coordinated response.

PostgreSQL 19 eliminates the 32-bit MultiXactOffset ceiling that has crashed high-concurrency FK-heavy clusters at 3 a.m.

Most organizations that build data lakes don't need them.

I need your feedback to either convince Marketing that I’m a genius and they should put these GitHub Codespaces Walkthroughs on our website, or to tell me I need to keep looking for different ways to make Quickstarts easier.Bi-directional logical replication is not a simple thing. It's a genuinely complicated problem, and getting it right across multiple nodes in a distributed PostgreSQL cluster is hard. That's what makes what we do at pgEdge special: we've done the hard engineering so you don't have to.

Two conferences. Two cities. Two completely different personalities. And me, somewhere in the middle, trying to keep up. 😄

First stop Helsinki, March 24. Nordic PGDay 2026. The Finns are punctual, focused, and deadly serious about PostgreSQL. Talks start on time. Coffee is strong. Silence is not awkward, it is just how things are. I loved every minute of it.

Prevent MultiXact ID wraparound by controlling when autovacuum freezes old locks.

#​647 — May 6, 2026

Web Version

Postgres Weekly

Postgres 19 Features I'm Excited About — An opinionated run-through of some v19 highlights, including pg_plan_advice, DDL extraction functions, online REPACK/REPACK CONCURRENTLY, and observability improvements.

Tianzhou (Bytebase)

Aurora PostgreSQL separates compute and storage, replicating redo records across three Availability Zones.

At a couple recent conferences, I got to describe the process Postgres uses to select new committers/maintainers. Usually to users and developers using Postgres, but in some cases it was unclear even to experienced Postgres contributors.

The official docs are rather brief, and don’t explain various important details. Let me explain how I understand the informal process, who’s responsible for what etc.

The window for new features in PostgreSQL 19 has closed with the Commitfest PG19-Final on April 9th. 182 patches were committed in this commitfest alone (plus more in the preceding ones). No new features are being accepted for PostgreSQL 20 yet, the git branches for 19 and 20 will likely be branched off in June. Currently the focus of the PostgreSQL community is on stabilizing PostgreSQL 19 so it is ready for release at the end of summer. If everything goes well, it will be released in September 2026.

Gülçin Yıldırım Jelinek organized the Prague PostgreSQL Meetup on 27 April, 2026 Artjoms Iskovs and Andreas Scherbaum presented at the Meetup.

Cornelia Biacsics organized the PostgreSQL User Group Vienna Meetup #2 on 28th April, 2026. Bernd Reiß and Sahil Sharma spoke at the event.

Raising autovacuum_max_workers above 3 won't speed up vacuum unless you also increase autovacuum_vacuum_cost_limit—the I/O budget is divided among workers, not…

The recent archival of pgBackRest has created an important and necessary conversation in the PostgreSQL community, not only about one project, one maintainer, or one repository, but about how we think about open-source software once it becomes part of critical enterprise infrastructure.

PostgreSQL 19 finally makes logical replication and physical standbys work together safely.

This post was originally published on the Microsoft Tech Community Blog.

Introduction

At small scale, using Postgres as a job queue is totally fine, and I’d even say it’s the right call. Fewer moving parts, one less system to manage, ACID guarantees on your jobs. What’s not to love?

PgQue's zero-mutation queue algorithm eliminates the "queue death spiral" by replacing UPDATE-and-DELETE with snapshot diffing.

PostgreSQL wraps transaction IDs every two billion transactions—autovacuum_freeze_max_age stops your database from crashing when it does.

After Part 1 and Part 2, here comes the Friday schedule! I hope that on the second day of the conference, I will have more time to attend different talks and actually stay and listen!

Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.