中文 English Français Русский Español العربية

Christophe Pettus: All Your GUCs in a Row: recovery_min_apply_delay

Planet PostgreSQL2026-10-20 21:000 views

recovery_min_apply_delay makes a standby late on purpose. For the length of the delay there is a running, queryable copy of your database on which the DELETE without a WHERE clause has not happened yet. That is the whole feature, and it is a good one. The problem is that almost everyone who sets … (I consult on PostgreSQL through PGX Inc..)

Source：https://postgr.es/p/9z9

My favorites

PreviousChristophe Pettus: Binary read replicas in PostgreSQL, Part 1 NextChristophe Pettus: All Your GUCs in a Row: recovery_init_sync_method

Building an AI Chatbot with Spring Boot and the OpenAI API (2026 Guide)

This is a summary of the full tutorial published on howtostartprogramming.in . TL;DR Aspect Details Tech Stack Java 17,

0dev.to Machine Learning

Automate Telegram Webhook Deployments and Log Purges via Yii2 Console Commands

Deploying a Telegram bot into a production environment requires more than just an HTTP endpoint to accept incoming updat

0dev.to PHP

Parsing WhatsApp chat exports: what real files taught me

A WhatsApp "Export chat" file looks easy: one line per message, a date, a name, some text. I wrote a parser for it, then

0dev.to Programming

A Brighter Flashlight Makes the Release Look Late

A better bug finder does not mean the code got worse. It means you can finally see the bottle caps from 1987, and someon

0dev.to Programming

Building a Minimal Model Context Protocol (MCP) Server in 30 Lines of TypeScript

If you've been experimenting with Anthropic's Claude Code, Claude Desktop, Cursor, or Cline, you've likely seen the Mode

0dev.to TypeScript

AWS contributes a large-transaction binary log optimization to MySQL

When MySQL commits a large transaction carrying gigabytes of changes, writing it to the binary log (binlog) can freeze e

0AWS Database Blog