All Your GUCs in a Row: restore_command
PostgreSQL's `restore_command` asks for WAL segments one at a time until the command fails—and that failure marks the archive's end, whether it's real or not.
All Your GUCs in a Row: restart_after_crash
When a PostgreSQL backend crashes, the postmaster can restart itself automatically or exit and wait for external intervention.
All Your GUCs in a Row: reserved_connections
PostgreSQL 16's `reserved_connections` reserves slots for your monitoring and backup roles when the application exhausts the pool.
All Your GUCs in a Row: remove_temp_files_after_crash
Protect your disk from orphaned temporary files after a backend crash.
All Your GUCs in a Row: recursive_worktable_factor
PostgreSQL 15's `recursive_worktable_factor` helps you fix slow recursive CTEs by tuning a single estimate.
All Your GUCs in a Row: the recovery_target parameters
Restore to the moment before the disaster using eight parameters that answer where replay stops, which timeline to follow, and what to do when you get there.
Binary read replicas in PostgreSQL, Part 3
Create replicas with a single command, but master the procedure for replacing a failed primary—that's where things get tricky and installations break.
All Your GUCs in a Row: recovery_prefetch
Standby lagging on network storage? `recovery_prefetch` lets WAL replay ask the kernel to read pages before it needs them, turning seventeen minutes of…
Binary read replicas in PostgreSQL, Part 2
Read replicas are one tool, but tuning a replica for one job and sending it another is a recipe for conflict.
All Your GUCs in a Row: recovery_min_apply_delay
Delay a standby on purpose to keep a queryable copy of your database before the DELETE without a WHERE clause happened.