Re: Replication lag

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Wasim Devale <wasimd60@xxxxxxxxx>
Subject: Re: Replication lag
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Fri, 18 Apr 2025 13:08:50 +0200
Cc: "Gaspare Boscarino, P.Eng." <gaspare.boscarino@xxxxxxxxxxxxxxxxxxx>, Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CAB5fag7w3vq_mzENSKrGYgJrBxL4wN1W6oVKbFb4kjUEYVwbLQ@mail.gmail.com>
References: <CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com> <CAB5fag7aCOwDbdjNyGkanANBL_k_GZ=YTc3Pd8NnVBuM7CUckQ@mail.gmail.com> <CALFaTbNJZODDhn_tWzo-kggLE9gtWwC8agJXx3SNpk7g=wqU+A@mail.gmail.com> <b14b297b691d8d89226bd93c97d5df0eeed1c30c.camel@cybertec.at> <CAB5fag7w3vq_mzENSKrGYgJrBxL4wN1W6oVKbFb4kjUEYVwbLQ@mail.gmail.com>
User-agent: Evolution 3.54.3 (3.54.3-1.fc41)

On Fri, 2025-04-18 at 16:21 +0530, Wasim Devale wrote:
> So finally long running on a replica won't minimise replication lag to zero in any scenario? Correct?

I am not sure I understand that sentence correctly.

Yes, if you are running long-running queries on a standby server, that
won't minimize replication lag.  But I am surprised that anyone could
imagine it would.

Yours,
Laurenz Albe

References:
- Replication lag
  - From: Wasim Devale
- Re: Replication lag
  - From: Wasim Devale
- Re: Replication lag
  - From: Gaspare Boscarino, P.Eng.
- Re: Replication lag
  - From: Laurenz Albe
- Re: Replication lag
  - From: Wasim Devale

Prev by Date: Re: Replication lag
Next by Date: Inquiry About Sharing a Job Opportunity with the PostgreSQL Community
Previous by thread: Re: Replication lag
Next by thread: Re: Replication lag
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]