Replication lag

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Replication lag
Date: 2025-04-17 05:51:30
Message-ID: CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everyone,

We have a setup of primary and replica database. We are using the replica
as read only purpose. But the queries are long running queries that takes
30 minutes to complete.

Do we have any settings in place that will not show replication lag and the
queries also executes on replica database without competition on WAL reply?

The settings:
Hot standby is off
And maximum streaming delay is set to -1

Thanks,
Wasim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wasim Devale 2025-04-17 12:14:32 Re: Replication lag
Previous Message Holger Jakobs 2025-04-15 17:00:34 Re: How to increase the max query history stored