From: Rob Sargent <robjsargent@gmail.com>
Message-Id: <6072813E-9311-41CD-9987-89DD456098AC@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_FFE4C13E-ECE7-4C2F-925A-7E45826EB7C4"
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.15\))
Subject: Re: Query optimization
Date: Thu, 13 Mar 2025 20:49:04 -0600
In-Reply-To: <CAJCZko+jAv98MZJp0T8KthDoWKdmhKTk-XukQJ1CR-v=+mSRhg@mail.gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 pgsql-general <pgsql-general@lists.postgresql.org>,
 laurenz.albe@cybertec.at
To: Durgamahesh Manne <maheshpostgres9@gmail.com>
References: <CAJCZkoL+DHs0H9enQEg8JXZw=7032zrmFKG8Vx0fup6_wqNpnQ@mail.gmail.com>
 <b319261b-3e06-41f9-9772-1a1747ede2b1@aklaver.com>
 <CAJCZkoLSaApgwHuWepO4EUENtjKMy1oX+GpEsFW4D+gFKoN_GQ@mail.gmail.com>
 <77CFD347-1A36-4A78-8D95-21569977C0A5@gmail.com>
 <CAJCZko+jAv98MZJp0T8KthDoWKdmhKTk-XukQJ1CR-v=+mSRhg@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/6072813E-9311-41CD-9987-89DD456098AC%40gmail.com>
Precedence: bulk


--Apple-Mail=_FFE4C13E-ECE7-4C2F-925A-7E45826EB7C4
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8


> On Mar 13, 2025, at 8:39 PM, Durgamahesh Manne =
<maheshpostgres9@gmail.com> wrote:
>=20
>=20
>=20
> On Fri, 14 Mar, 2025, 08:04 Rob Sargent, <robjsargent@gmail.com =
<mailto:robjsargent@gmail.com>> wrote:
>=20
> Hi
>=20
> Gave you plan with out limit . Stats up to date insert .....on =
conflict do nothing runs some times=20
>=20
> Regards=20
> Durga Mahesh
>=20
>=20

But still using the =E2=80=9Cselect exists=E2=80=9D, thereby turning the =
result into a true/false value?  I do not follow your point on the usage =
of =E2=80=9Con conflict=E2=80=9D.  Is this also something whose =
behaviour has changed recently?  I assume it references the same table =
as the original sql?


--Apple-Mail=_FFE4C13E-ECE7-4C2F-925A-7E45826EB7C4
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;" class=3D""><br =
class=3D""><div><br class=3D""><blockquote type=3D"cite" class=3D""><div =
class=3D"">On Mar 13, 2025, at 8:39 PM, Durgamahesh Manne &lt;<a =
href=3D"mailto:maheshpostgres9@gmail.com" =
class=3D"">maheshpostgres9@gmail.com</a>&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div class=3D""><div dir=3D"auto" =
class=3D""><div class=3D""><br class=3D""><br class=3D""><div =
class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" =
class=3D"gmail_attr">On Fri, 14 Mar, 2025, 08:04 Rob Sargent, &lt;<a =
href=3D"mailto:robjsargent@gmail.com" =
class=3D"">robjsargent@gmail.com</a>&gt; wrote:<br =
class=3D""></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
style=3D"word-wrap:break-word;line-break:after-white-space" class=3D""><br=
 class=3D""><div class=3D"">Hi</div></div></blockquote></div></div><div =
dir=3D"auto" class=3D""><br class=3D""></div><div dir=3D"auto" =
class=3D"">Gave you plan with out limit . Stats up to date insert =
.....on conflict do nothing runs some times&nbsp;</div><div dir=3D"auto" =
class=3D""><br class=3D""></div><div dir=3D"auto" =
class=3D"">Regards&nbsp;</div><div dir=3D"auto" class=3D"">Durga =
Mahesh</div><div dir=3D"auto" class=3D""><div class=3D"gmail_quote =
gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"margin:0=
 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
style=3D"word-wrap:break-word;line-break:after-white-space" =
class=3D""><div class=3D""><span style=3D"font-family:CourierNewPSMT" =
class=3D""><br class=3D""></span></div><div class=3D""><span =
style=3D"font-family:CourierNewPSMT" class=3D""><br =
class=3D""></span></div></div></blockquote></div></div></div>
</div></blockquote></div><br class=3D""><div class=3D"">But still using =
the =E2=80=9Cselect exists=E2=80=9D, thereby turning the result into a =
true/false value? &nbsp;I do not follow your point on the usage of =E2=80=9C=
on conflict=E2=80=9D. &nbsp;Is this also something whose behaviour has =
changed recently? &nbsp;I assume it references the same table as the =
original sql?</div><div class=3D""><br class=3D""></div></body></html>=

--Apple-Mail=_FFE4C13E-ECE7-4C2F-925A-7E45826EB7C4--