Re: PostgreSQL 9.2 high replication lag

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(at)gmail(dot)com> wrote:

> On Fri, Jul 16, 2021 at 12:38 AM Lucas <root(at)sud0(dot)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?
>
> Luca
>
>
>