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:
https://www.cybertec-postgresql.com/en/streaming-replication-conflicts-in-postgresql/
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com