"Maciej Babinski" <maciej+postgres(at)apathy(dot)killer-robot(dot)net> writes:
> Hash join of columns with many null fields is very slow unless the null
> fields are commented out.
I see no bug here. AFAICT your "much faster" query gets that way by
having eliminated all the candidate join rows on the B side.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Maciej Babinski||Date: 2007-01-26 16:15:25|
|Subject: Re: BUG #2930: Hash join abyssmal with many null fields.|
|Previous:||From: inifinity||Date: 2007-01-25 16:32:33|
|Subject: BUG #2934: INSTALL FAILURE - failed to set permissions on the installed files|