Re: PostgreSQL 9.2 high replication lag - Mailing list pgsql-general

From Ninad Shah
Subject Re: PostgreSQL 9.2 high replication lag
Date
Msg-id CAOFEiBdttmeyPznfXWOvKe40gy9X2n2DzWbWe9M-vAt4FBfZyw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.2 high replication lag  (Luca Ferrari <fluca1978@gmail.com>)
Responses Re: PostgreSQL 9.2 high replication lag  (Lucas <root@sud0.nz>)
List pgsql-general
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@gmail.com> wrote:
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?

Luca


pgsql-general by date:

Previous
From: Mayan
Date:
Subject: pg_restore (fromuser -> touser)
Next
From: Ninad Shah
Date:
Subject: Re: pg_restore (fromuser -> touser)