Sammlung von Newsfeeds

Christophe Pettus: REPACK Moves In

Neues vom PostgreSQL Planet - 29. April 2026 - 20:34
For about fifteen years, the standard answer to “this table is bloated, what do I actually do about it” has been one of the out-of-tree options: pg_repack (the extension), pg_squeeze (Antonin Houska’s predecessor work), or a hand-rolled CREATE TABLE AS and swap. PG19 changes tha…

Jimmy Angelakos: PostgresEDI April 2026 Meetup Recap & May Lightning Talks

Neues vom PostgreSQL Planet - 29. April 2026 - 13:00

Another great evening for the PostgresEDI community! 🐘

First off, a massive thank you to everyone who came out to our April meetup. The discussions were brilliant, and it's amazing to see new faces come to experience the friendly environment at our meetups.

Christophe Pettus: All Your GUCs in a Row: archive_timeout

Neues vom PostgreSQL Planet - 29. April 2026 - 3:00
The archiver only runs when a WAL segment is complete. On a busy database that happens constantly; on a quiet one it might not happen for hours or days. archive_timeout exists to prevent the resulting “our database has been accepting writes all afternoon but none of them are in the archive …

Henrietta Dombrovskaya: PG DATA 2026: The talks I am most excited about. Part 1

Neues vom PostgreSQL Planet - 29. April 2026 - 2:40

Hello everyone, here comes a series of my annual posts about the Chicago Postgres Conference, and what I am most excited about. And I want to start with the training sessions we offer. All three training sessions are presented by my favorite people, and I can’t wait to tell you more about them!

Stefanie Janine: PostgreSQL Ecosystem Problems

Neues vom PostgreSQL Planet - 29. April 2026 - 0:00
PgBackRest Is Dead

Yesterday the maintainer of PgBackRest, David Steele, published the NOTICE OF OBSOLESCENCE.

For further information please read the blog post pgBackRest is dead. Now what? by Lætitia Avrot. She also points to how to go an as she, like me, always recommended PgBackRest for PostgreSQL backups.

Christophe Pettus: Managed Postgres, Examined: Amazon RDS for PostgreSQL

Neues vom PostgreSQL Planet - 28. April 2026 - 23:00
First in a series of dispassionate surveys of the major managed-Postgres offerings. This post is about Amazon RDS for PostgreSQL — what AWS calls “traditional RDS,” as distinct from Aurora PostgreSQL, which is a separate product with a separate architecture and will get its own post. …

Radim Marek: HOT Updates in Postgres

Neues vom PostgreSQL Planet - 28. April 2026 - 22:23

In the previous article we watched every UPDATE leave dead tuple behind. The same copy-on-write behaviour shows up from the operational angle in DELETEs are difficult. That's the tradeoff of MVCC and on the heap alone it's tolerable. The problem is the indexes.

Christophe Pettus: Parallel Autovacuum: It’s Not About The CPU

Neues vom PostgreSQL Planet - 28. April 2026 - 21:00
PostgreSQL 19 ships with parallel autovacuum. The new GUC autovacuum_max_parallel_workers caps the cluster-wide pool, and the per-table storage parameter autovacuum_parallel_workers lets you tune individual tables. Workers come out of the existing max_parallel_workers budget. Off by default. Good…

Christophe Pettus: Permissive by Choice, Permanent by Accident

Neues vom PostgreSQL Planet - 28. April 2026 - 21:00
Stephen O’Grady’s State of Open Source Licensing in 2026 at RedMonk is essential reading. The headline finding — that the long shift from copyleft to permissive licensing has continued, with Apache and MIT consolidating their dominance among the survivors — surprises no one who has be…

Jan Wieremjewicz: pgBackRest is archived, what now?

Neues vom PostgreSQL Planet - 28. April 2026 - 13:00

pgBackRest is an open source backup and restore tool for PostgreSQL. It’s fair to say it’s one of the most popular options, widely used across the PostgreSQL ecosystem.

Cornelia Biacsics: Contributions for week 16, 2026

Neues vom PostgreSQL Planet - 28. April 2026 - 9:07

PGConf Germany 2026 took place on April 21 and April 22 2026 in Essen, Germany

Organized by:

  • Andreas Kretschmer
  • Andreas Scherbaum
  • Cornelia Biacsics
  • Daniel Westermann
  • Danilo Endesfelder
  • Dirk Krautschik
  • Julia Gugel
  • Kai Wagner
  • Sascha Spettmann

Speaker:

Gabriele Bartolini: Why the cycle of open-source sustainability needs to be virtuous

Neues vom PostgreSQL Planet - 28. April 2026 - 8:48

Yesterday, David Steele announced the end of life of pgBackRest — a PostgreSQL backup tool he maintained for thirteen years. The reasons are structural, not personal, and they are a reminder of a pattern we see too often in open-source infrastructure. This article reflects on what that means, on the architectural rivalry between pgBackRest and Barman, and on why CloudNativePG users can take confidence from both the project’s CNCF governance and the virtuous cycle of commercial support that sustains it.

Laurenz Albe: My queries to monitor autovacuum

Neues vom PostgreSQL Planet - 28. April 2026 - 7:00


© Laurenz Albe 2026

Over the years of training, consulting and supporting PostgreSQL users, I have come up with a number of queries to monitor autovacuum. Monitoring autovacuum is not a new requirement, so there are already many existing monitoring queries. However, not all of those queries are useful. So I thought it might be a good idea to write an article about my own collection, both as a reference for myself and as a service for PostgreSQL administrators everywhere.

Christophe Pettus: All Your GUCs in a Row: archive_mode

Neues vom PostgreSQL Planet - 28. April 2026 - 3:00
archive_mode is the master switch for WAL archiving. With the last three posts under our belts — archive_cleanup_command, archive_command, archive_library — we now get to the parameter that decides whether any of that machinery runs at all. Three values: off (default), on, and always. Context is …

Christophe Pettus: Notice of Obsolescence

Neues vom PostgreSQL Planet - 27. April 2026 - 20:20
Yesterday David Steele announced that he is stepping away from pgBackRest. After thirteen years, the most widely-deployed dedicated backup tool in the PostgreSQL ecosystem is no longer maintained. The current release, v2.58.0, is the last release. Steele asks that any forks pick a new name, which…

Christophe Pettus: Retail DDL Arrives, One Function at a Time

Neues vom PostgreSQL Planet - 27. April 2026 - 15:00
For thirty years, the answer to “how do I get the DDL for this object?” in PostgreSQL has been: shell out to pg_dump -s and grep. Every tool that has ever needed to reconstruct an object definition — migration tools, schema diff utilities, \d replacements, every ORM that has tried to …

Christophe Pettus: Online Checksums Are Not Instant

Neues vom PostgreSQL Planet - 27. April 2026 - 15:00
For about fifteen years the answer to “can I turn on data checksums without an initdb?” has been “not really.” pg_checksums showed up in PostgreSQL 12 and made the job survivable, but you still had to shut the cluster down. For anyone running 24×7 production, that has left…

Richard Yen: Understanding Bitmap Heap Scans in PostgreSQL

Neues vom PostgreSQL Planet - 27. April 2026 - 10:00
Introduction

When people first start reading PostgreSQL execution plans, they quickly learn a few common scan types: Seq Scan, Index Scan, Index Only Scan. But eventually another one appears that is less obvious: Bitmap Heap Scan, which is almost always accompanied by Bitmap Index Scan.

Christophe Pettus: All Your GUCs in a Row: archive_library

Neues vom PostgreSQL Planet - 27. April 2026 - 3:00
Before getting into this one, an errata against the previous post. I said backup tools “can register as an archive_library and bypass archive_command entirely” on PostgreSQL 15+. That is what the feature was designed to enable. It is not what the ecosystem has actually shipped. More o…

Lætitia AVROT: pgBackRest is dead. Now what?

Neues vom PostgreSQL Planet - 27. April 2026 - 2:00
I have been recommending pgBackRest as the best backup tool for PostgreSQL for years. I even wrote a blog post about it. My students at Université Lyon I were able to backup, restore, and perform PITR in four hours with zero prior knowledge of the tool. That is how good it was. I say “was” because David Steele, the sole maintainer of pgBackRest, has announced on the project’s GitHub page that he is stopping all work on the project.

Seiten