Hi, On 2018-09-11 16:23:44 +0100, Simon Riggs wrote: > It's hard to see how any reasonable workload would affect the standby. And > if it did, you'd change the parameter and restart, just like you already > have to do if someone changes max_connections on master first.
Isn't one of the most common ways to run into "out of shared memory" "You might need to increase max_locks_per_transaction." to run pg_dump? And that's pretty commonly done against standbys? Greetings, Andres Freund