Re: Replication lag

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Wasim Devale <wasimd60(at)gmail(dot)com>
Cc: "Gaspare Boscarino, P(dot)Eng(dot)" <gaspare(dot)boscarino(at)theoremasystems(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Replication lag
Date: 2025-04-18 11:08:50
Message-ID: 6e85abdb00db4ec0cd8220373b4610838d8a3455.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Suman Sangha 2025-04-19 10:38:51 Inquiry About Sharing a Job Opportunity with the PostgreSQL Community
Previous Message Wasim Devale 2025-04-18 10:51:20 Re: Replication lag