MIME-Version: 1.0
References: <CAD=mzVXR3GjM0vcthMBwEdbOKqSKcv8oojSS9coczWRi9BRYTA@mail.gmail.com>
 <abd3bc064d16bc93a2d8661a692903da97d2c154.camel@cybertec.at>
 <CAD=mzVVvK8xk-9m8h3Xu27cGN7BW329HKYdO+0EMXfWvSD3AGA@mail.gmail.com>
 <bed28c629a839b1f354e18f416a87fd5f4f78ba7.camel@cybertec.at>
 <CAD=mzVVqR-mKUFHetsejFWSPQPbLjTVhCmBebJTFX5XmYp+nGg@mail.gmail.com>
 <891bcfec74f7358ef0212caf6565a35153dd2941.camel@cybertec.at>
 <CAD=mzVXRkNM6ATTtnCsZeA0sfD6S_UPU=i6vfMTfoTBuT0pKTw@mail.gmail.com>
 <CAEzWdqdix_ftiUuPJp_LZ3QjB6rDmHVfxtdVMOn+akhMAWEOGw@mail.gmail.com> <CAD=mzVX1HuqQuMZx2QCy8ybJCG43zzxY4mqY4pM_gpxKscadBw@mail.gmail.com>
In-Reply-To: <CAD=mzVX1HuqQuMZx2QCy8ybJCG43zzxY4mqY4pM_gpxKscadBw@mail.gmail.com>
From: =?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@gmail.com>
Date: Sun, 26 May 2024 10:13:28 +0200
Message-ID: <CAKkG4_nLNSDSDd7emC+p4rEicmeCBCBJozzy3QRFvO7BWh3SRA@mail.gmail.com>
Subject: Re: Long running query causing XID limit breach
To: sud <suds1434@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007c5fe6061956fa87"
Archived-At: <https://www.postgresql.org/message-id/CAKkG4_nLNSDSDd7emC%2Bp4rEicmeCBCBJozzy3QRFvO7BWh3SRA%40mail.gmail.com>
Precedence: bulk

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

On Sat, May 25, 2024 at 11:00=E2=80=AFPM sud <suds1434@gmail.com> wrote:

>
> But i have one question here , does max_standby_streaming_delay =3D 14 ,
> means the queries on the standby will get cancelled after 14 seconds?
>

No, your query gets cancelled when it stalls replication for >14 sec. If
your master is idle and does not send any WAL and the replica has
caught up, the query can take as long as it wants.

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, May 25, 2024 at 11:00=E2=80=AFPM =
sud &lt;<a href=3D"mailto:suds1434@gmail.com" target=3D"_blank">suds1434@gm=
ail.com</a>&gt; wrote:<br></div><div dir=3D"ltr"><div class=3D"gmail_quote"=
><blockquote 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"ltr"><div di=
r=3D"ltr"><br></div><div class=3D"gmail_quote"><div>But i have one question=
 here , does=C2=A0max_standby_streaming_delay =3D 14 , means the queries on=
 the standby will get cancelled after 14 seconds?</div></div></div></blockq=
uote><div><br></div><div>No, your query gets cancelled when it stalls repli=
cation for &gt;14 sec. If your master is idle and does not send any WAL and=
 the replica has caught=C2=A0up, the query can take as long as it wants.=C2=
=A0</div></div></div>
</div>

--0000000000007c5fe6061956fa87--