Hello
On Mon, 1 Dec 2003, Graham Leggett wrote: > Hi all, > > I am trying to do a query that returns all rows that are _not_ part of > a join, and so far I cannot seem to find a query that doesn't take 30 > minutes or more to run. > > The basic query is "select * from tableA where tableA_id NOT IN (select > tableA_id from tableB)". > > Is there a more efficient way of doing this? > > Regards, > Graham > -- > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
