Re: PostgreSQL 9.2 high replication lag

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Lucas <root(at)sud0(dot)nz>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 9.2 high replication lag
Date: 2021-07-23 09:47:57
Message-ID: CAKoxK+7GWav4HDwCrNCg33_TsrjERHq49CunwxRyALTofYUjPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2021-07-23 10:05:19 Re: pg_dumpall with individual output files per database?
Previous Message Marcin Barczynski 2021-07-23 06:09:18 Re: Why does VACUUM FULL pg_class sometimes wait for ShareLock on another transaction after getting AccessExclusiveLock on pg_class?