Re: subquery performance and EXISTS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: subquery performance and EXISTS
Date
Msg-id 4091.946483646@sss.pgh.pa.us
Whole thread Raw
In response to subquery performance and EXISTS  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Re: subquery performance and EXISTS
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Index corruption
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Index corruption