Version 9.2 is very old and has a lot of issues related to streaming replication. Additionally, it is already EOL.
Furthermore, max_standby_streaming_delay has no relation with the streaming lag. It's associated with queries conflicting with data. This parameter will not speed up the WAL apply operation.
On Fri, Jul 16, 2021 at 12:38 AM Lucas <root@sud0.nz> wrote: > However, it hasn't changed and the replication lag is still high all the time. >
Since the documentation states that max_standby_streaming_delay "[...]it is the maximum total time allowed to apply WAL data once it has been received from the primary server[...]", could it be the trivial explaination that the master is serving WALs with an high delay?