MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Tue, 11 Apr 2023 10:27:59 +0100
Message-ID: 
 <CA+i5JwYoxnYGHXn41AgnN9iJP8FCMDMozgzsn5hc0tvhSSMNVg@mail.gmail.com>
Subject: Looking for an efficient way to replace efficient NOT IN when
 landling very large data
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002a5c7805f90c1cba"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwYoxnYGHXn41AgnN9iJP8FCMDMozgzsn5hc0tvhSSMNVg%40mail.gmail.com>
Precedence: bulk

--0000000000002a5c7805f90c1cba
Content-Type: text/plain; charset="UTF-8"

Select a.id, a.name, b.id, b.name from a_large_table a, definitive b where (
a.id, b.name) not in
(select b.id, b.name from definitive b)

is very slow.

Is there a faster way to do so?

Regards,

David

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

<div dir=3D"ltr">Select <a href=3D"http://a.id">a.id</a>, <a href=3D"http:/=
/a.name">a.name</a>, <a href=3D"http://b.id">b.id</a>, <a href=3D"http://b.=
name">b.name</a> from a_large_table a, definitive b where (<a href=3D"http:=
//a.id">a.id</a>, <a href=3D"http://b.name">b.name</a>) not in=C2=A0<div>(s=
elect <a href=3D"http://b.id">b.id</a>, <a href=3D"http://b.name">b.name</a=
> from definitive b)</div><div><br></div><div>is very slow.</div><div><br><=
/div><div>Is there a faster way to do so?</div><div><br></div><div>Regards,=
</div><div><br></div><div>David</div></div>

--0000000000002a5c7805f90c1cba--