Re: [HACKERS] Idea for speeding up uncorrelated subqueries

> Bruce Momjian wrote:
> > 
> > Yes, the subqueries need work.  We don't even do index lookups into the
> > inner plan, only sequential.  Already on TODO.  The multiple query
>               ^^^^^^^^^^^^^^^
> What? Indices are used when appropriate.

Sorry, bad wording.  My English should be better.  :-)

I meant to say that joins from the outer plan to subplan are always
nested loops, not hash or mergejoins.  If you have something like:
delete from tab where col in (select col2 from largetable)

it takes a long time, when it really should be quick.  That is why
people are encouraged to use EXISTS.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026