On Tue, 2021-12-14 at 13:38 +0100, Marc Millas wrote: > but... when you do setup a streaming replication, there is, in postgresql.conf, a variable: > max_standby_streaming_delay = 30s # max delay before canceling queries when reading streaming WAL; > > as the secondary is, by nature, read only, I was wondering why it can be necessary to cancel a read request...
Perhaps this can explain some of what is going on: