Postgres Pro
Downloads
Home   >   mailing lists

Looking for an efficient way to replace efficient NOT IN when landling very large data - Mailing list pgsql-sql

From Shaozhong SHI
Subject Looking for an efficient way to replace efficient NOT IN when landling very large data
Date
Msg-id CA+i5JwYoxnYGHXn41AgnN9iJP8FCMDMozgzsn5hc0tvhSSMNVg@mail.gmail.com
Whole thread Raw
Responses Re: Looking for an efficient way to replace efficient NOT IN when landling very large data
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: nikhil raj
Date:
Subject: 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
Next
From: David Rowley
Date:
Subject: Re: Looking for an efficient way to replace efficient NOT IN when landling very large data