Re: No hash join across partitioned tables?

Tom Lane wrote:
> Kris Jurka <books@ejurka.com> writes:
>> The hash join takes less than twenty seconds, the other two joins I 
>> killed after five minutes.  I can try to collect explain analyze results 
>> later today if you'd like.
> 

Attached are the explain analyze results.  The analyze part hits the 
hash join worst of all, so I've also included the timings without analyzing.

Method       Time (ms)  Time w/Analyze (ms)
nestloop     304853     319060
merge        514517     683757
hash          18957     143731

Kris Jurka