Sammlung von Newsfeeds

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.

PostgreSQL 19 changes this week ALTER TABLE ALTER TABLE ... SPLIT PARTITION ... syntax added ALTER TABLE ... MERGE PARTITIONS ... syntax added pg_stat_progress_analyze column started_by added pg_stat_progress_vacuum columns mode and started_by added vacuumdb option --dry-run added PostgreSQL 18 articles Postgres 18 New Default for Data Checksums and How to Deal with Upgrades (2025-12-11) - Greg Sabino Mullane / Crunchy Data

more...

As we wrap up 2025 and prepare for another exciting year of 2026, HexaCluster is back again with our annual Summary of PostgreSQL in 2025, continuing the tradition we set in 2024.