Re: PostgreSQL 9.2 high replication lag

‐‐‐ Original Message ‐‐‐ On Friday, August 20th, 2021 at 5:29 PM, Laurenz Albe laurenz.a...@cybertec.at wrote: > On Fri, 2021-08-20 at 01:33 +, Lucas wrote: > > > After setting max_standby_streaming_delay to 120s it got a lot better. > > > > But the replication delay is still hap

Re: PostgreSQL 9.2 high replication lag

‐‐‐ Original Message ‐‐‐ On Friday, August 20th, 2021 at 4:56 PM, Ben Madin wrote: > I realise you may have other complications, but we have upgraded numerous > v9.6 servers (on AWS) to v12 in the last year, with basically no problems in > the upgrade, and many less problems with stream

Re: PostgreSQL 9.2 high replication lag

On Fri, 2021-08-20 at 01:33 +, Lucas wrote: > After setting max_standby_streaming_delay to 120s it got a lot better. > But the replication delay is still happening quite often, except this time > goes up to 120s only. That's exactly what this parameter should do. If you don't want the delay

Re: PostgreSQL 9.2 high replication lag

Hello guys. After setting max_standby_streaming_delay to 120s it got a lot better. But the replication delay is still happening quite often, except this time goes up to 120s only. [image.png] I know that max_standby_streaming_delay stands for how long the standby server should wait before canc

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. Agreed. > Furthermore, max_standby_streaming_delay has no relation with the streaming > lag. It's associated with queries conflicting with data. This parameter will > not spee

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 ope

Re: PostgreSQL 9.2 high replication lag

On Fri, Jul 16, 2021 at 12:38 AM Lucas 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

Re: PostgreSQL 9.2 high replication lag

‐‐ Original Message ‐‐‐ On Wednesday, July 14th, 2021 at 5:30 PM, Laurenz Albe laurenz.a...@cybertec.at wrote: On Tue, 2021-07-13 at 20:14 -0700, David G. Johnston wrote: > > On Tue, Jul 13, 2021 at 8:01 PM Lucas r...@sud0.nz wrote: > > > > > According to the documentation, max_standb

Re: PostgreSQL 9.2 high replication lag

On Tue, 2021-07-13 at 20:14 -0700, David G. Johnston wrote: > On Tue, Jul 13, 2021 at 8:01 PM Lucas wrote: > > According to the documentation, max_standby_streaming_delay is a > > configuration parameter > > determining how long a standby server should wait before canceling queries > > that conf

Re: PostgreSQL 9.2 high replication lag

On Tue, Jul 13, 2021 at 8:01 PM Lucas wrote: > According to the documentation, max_standby_streaming_delay is a configuration > parameter determining how long a > standby server should wait before canceling queries that conflict with > pending WAL entries receive

Re: PostgreSQL 9.2 high replication lag

Okay. Looks like I found the "issue". A while ago we set max_standby_streaming_delay to -1, because we were getting to many errors "ERROR: canceling statement due to conflict with recovery.". According to the documentation, max_standby_streaming_delay is aconfiguration parameterdetermining how