PostgreSQL's recovery_prefetch has sighup context, so a lagging standby can try it off with ALTER SYSTEM SET recovery_prefetch = off and SELECT pg_reload_conf(), no restart. wal_decode_buffer_size, its lookahead limit, does need a restart.
0 reposts0 likes