Postgres Pro
Downloads
Home   >   mailing lists

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

From Luca Ferrari
Subject Re: PostgreSQL 9.2 high replication lag
Date
Msg-id CAKoxK+7GWav4HDwCrNCg33_TsrjERHq49CunwxRyALTofYUjPg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.2 high replication lag  (Lucas <root@sud0.nz>)
Responses Re: PostgreSQL 9.2 high replication lag  (Ninad Shah <nshah.postgres@gmail.com>)
List pgsql-general
Tree view 
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: Marcin Barczynski
Date:
Subject: Re: Why does VACUUM FULL pg_class sometimes wait for ShareLock on another transaction after getting AccessExclusiveLock on pg_class?
Next
From: Luca Ferrari
Date:
Subject: Re: pg_dumpall with individual output files per database?