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.
Kindly consider upgrading to a supported version.
Regards,
Ninad Shah
On Fri, 23 Jul 2021 at 15:18, Luca Ferrari <fluca1978@xxxxxxxxx> wrote:
On Fri, Jul 16, 2021 at 12:38 AM Lucas <root@xxxxxxx> 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?
Luca
