Sammlung von Newsfeeds

Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.

Meet the mentee: Anushka Saxena worked with the project maintainers on transforming the documentation for CloudNativePG, as part of the LFX mentorship program.

At first glance, the idea that an idle session could lead to a transaction wraparound might seem counterintuitive. Most PostgreSQL users are familiar with how long-running queries or open transactions can cause table bloat and wraparound risks by pinning the xmin horizon, which prevents autovacuum from reclaiming dead tuples and Transaction IDs.

PostgreSQL 19 changes this week cumulative statistics support for reading/writing auxiliary data from/to disk added pg_createsubscriber support for handling existing publications added pg_sync_replication_slots()  retry logic added PostgreSQL 18 articles PostgreSQL 18 Asynchronous Disk I/O - Deep Dive Into Implementation (2025-12-15) - Josef Machytka / Credativ

more...

When the database won't start and there's no backup available, most teams assume the game is over. But that's not true—the data is still on disk, it just lost the ability to speak. PostgreSQL data files remain transparent and readable, but here's the problem - without the data dictionary, you cannot understand what those bytes actually mean.

When people first hear "instant recovery," they often assume it is a replacement for backup—or worse, a risky shortcut only experts should attempt. But the truth is exactly the opposite. Instant recovery does not challenge any design boundary of PostgreSQL.