Looking for an efficient way to replace efficient NOT IN when landling very large data

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Looking for an efficient way to replace efficient NOT IN when landling very large data
Date: 2023-04-11 09:27:59
Message-ID: CA+i5JwYoxnYGHXn41AgnN9iJP8FCMDMozgzsn5hc0tvhSSMNVg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Rowley 2023-04-11 09:33:42 Re: Looking for an efficient way to replace efficient NOT IN when landling very large data
Previous Message nikhil raj 2023-02-27 19:45:46 Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range