Tom Lane wrote:
Maciej Babinski <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
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.
The additional clause eliminates no rows beyond what the existing
cl
Tom Lane wrote:
"Maciej Babinski" <[EMAIL PROTECTED]> 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 candida
The following bug has been logged online:
Bug reference: 2930
Logged by: Maciej Babinski
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: CentOS 4.4 (linux 2.6.9)
Description:Hash join abyssmal with many null fields.
Details:
Hash join of
