Re: PostgreSQL 9.2 high replication lag
| От | Ninad Shah |
|---|---|
| Тема | Re: PostgreSQL 9.2 high replication lag |
| Дата | |
| Msg-id | CAOFEiBdttmeyPznfXWOvKe40gy9X2n2DzWbWe9M-vAt4FBfZyw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL 9.2 high replication lag (Luca Ferrari <fluca1978@gmail.com>) |
| Ответы |
Re: PostgreSQL 9.2 high replication lag
|
| Список | 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 по дате отправления: