All Your GUCs in a Row: row_security
`row_security = off` doesn't disable row-level security—it triggers an error when a policy would apply.
All Your GUCs in a Row: restrict_nonsystem_relation_kind
PostgreSQL 16.4, 15.8, 14.13, 13.16 and 12.20 added a security parameter that only pg_dump uses.
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…