Re: [HACKERS] Re: subquery performance and EXISTS

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom, does it still look easy to change, and if so, can you change it to
> > hash?
> 
> We could probably do it, but there is the little problem that hash joins
> only work for a very limited set of data types and operators.  This
> wouldn't be a complete solution on its own.

How hard would it be to have the EXISTS be done automatically?  The
performance problem for subqueries has bothered me for two years now.  I
don't think I know enough to fix it, though.

--  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