public inbox for [email protected]  

help / color / mirror / Atom feed

From: Wasim Devale <[email protected]>
To: Pgsql-admin <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Replication lag
Date: Thu, 17 Apr 2025 11:21:30 +0530
Message-ID: <CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Replication lag
  In-Reply-To: <CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox