Christophe Pettus: All Your GUCs in a Row: recovery_min_apply_delay
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 ……
Sources
- T2Christophe Pettus: All Your GUCs in a Row: recovery_min_apply_delayPlanet PostgreSQL