MIME-Version: 1.0
References: 
 <CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com>
 <CAB5fag7aCOwDbdjNyGkanANBL_k_GZ=YTc3Pd8NnVBuM7CUckQ@mail.gmail.com>
In-Reply-To: 
 <CAB5fag7aCOwDbdjNyGkanANBL_k_GZ=YTc3Pd8NnVBuM7CUckQ@mail.gmail.com>
From: "Gaspare Boscarino, P.Eng." <gaspare.boscarino@theoremasystems.com>
Date: Thu, 17 Apr 2025 15:04:52 -0700
Message-ID: 
 <CALFaTbNJZODDhn_tWzo-kggLE9gtWwC8agJXx3SNpk7g=wqU+A@mail.gmail.com>
Subject: Re: Replication lag
To: Wasim Devale <wasimd60@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ec04c606330097b6"
Archived-At: 
 <https://www.postgresql.org/message-id/CALFaTbNJZODDhn_tWzo-kggLE9gtWwC8agJXx3SNpk7g%3DwqU%2BA%40mail.gmail.com>
Precedence: bulk

--000000000000ec04c606330097b6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello Wasim,

If I understand your problem correctly, you are trying to use the replica
to run queries for some kind of report. For those cases, I recommend
setting up a logical replication which will allow you to have a replica
that can be modified based on your needs. For instance, on the target
database (replica) you could create indices to improve the performance of
your query. An analysis of the execution plan would be necessary, of course=
.

Regards,

   Gaspare

On Thu, Apr 17, 2025 at 5:15=E2=80=AFAM Wasim Devale <wasimd60@gmail.com> w=
rote:

> Hi All
>
> Does wal_level =3D logical can resolve the issue of replication lag?
>
> On Thu, 17 Apr, 2025, 11:21=E2=80=AFam Wasim Devale, <wasimd60@gmail.com>=
 wrote:
>
>> Hi everyone,
>>
>> We have a setup of primary and replica database. We are using the replic=
a
>> as read only purpose. But the queries are long running queries that take=
s
>> 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
>>
>

--=20
Gaspare Boscarino, P.Eng., M.Eng., MASc.
Founder and CEO
*Theorema Systems Inc.*
www.theoremasystems.com | +1 604-765-0121

--000000000000ec04c606330097b6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hello Wasim,</div><div><br></div><div>If I understand=
 your problem correctly, you are trying to use the replica to run queries f=
or some kind of report. For those cases, I recommend setting up a logical r=
eplication which will allow you to have a replica that can be modified base=
d on your needs. For instance, on the target database (replica) you could c=
reate indices to improve the performance of your query. An analysis of the =
execution plan would be necessary, of course.<br></div><div><br></div><div>=
Regards,</div><div><br></div><div>=C2=A0=C2=A0 Gaspare</div></div><br><div =
class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail=
_attr">On Thu, Apr 17, 2025 at 5:15=E2=80=AFAM Wasim Devale &lt;<a href=3D"=
mailto:wasimd60@gmail.com">wasimd60@gmail.com</a>&gt; wrote:<br></div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div>Hi All=
=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Does wal_level =
=3D logical can resolve the issue of replication lag?<br><br><div class=3D"=
gmail_quote" dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, 17 =
Apr, 2025, 11:21=E2=80=AFam Wasim Devale, &lt;<a href=3D"mailto:wasimd60@gm=
ail.com" target=3D"_blank">wasimd60@gmail.com</a>&gt; wrote:<br></div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi everyone,=
<div dir=3D"auto"><br></div><div dir=3D"auto">We have a setup of primary an=
d replica database. We are using the replica as read only purpose. But the =
queries are long running queries that takes 30 minutes to complete.</div><d=
iv dir=3D"auto"><br></div><div dir=3D"auto">Do we have any settings in plac=
e that will not show replication lag and the queries also executes on repli=
ca database without competition on WAL reply?</div><div dir=3D"auto"><br></=
div><div dir=3D"auto">The settings:</div><div dir=3D"auto">Hot standby is o=
ff</div><div dir=3D"auto">And maximum streaming delay is set to -1</div><di=
v dir=3D"auto"><br></div><div dir=3D"auto">Thanks,</div><div dir=3D"auto">W=
asim=C2=A0</div></div>
</blockquote></div></div></div>
</blockquote></div><div><br clear=3D"all"></div><br><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Gaspare Boscarino, P.Eng., M.Eng., MASc.<div>Founder and CEO=
</div><div><b>Theorema Systems Inc.</b></div><div><font color=3D"#0000ff"><=
a href=3D"http://www.theoremasystems.com" target=3D"_blank">www.theoremasys=
tems.com</a></font> | +1 604-765-0121</div></div></div>

--000000000000ec04c606330097b6--