> 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
