Postgres recovery_prefetch can cause outages
PostgreSQL's recovery_prefetch feature, intended to speed up crash recovery by preloading data pages, has been found to trigger server outages under certain conditions. Researchers discovered that when the feature interacts with specific workload patterns, it can cause excessive memory usage and deadlocks, leading to crashes. The PostgreSQL community is evaluating patches to mitigate the issue.