Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #2930: Hash join abyssmal with many null fields.
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Maciej Babinski" <maciej+postgres(at)apathy(dot)killer-robot(dot)net>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #2930: Hash join abyssmal with many null fields.
- Date: Fri, 26 Jan 2007 00:49:52 -0500
"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
- Follow-Ups:
- Re: BUG #2930: Hash join abyssmal with many null fields.
- From: Maciej Babinski
- Re: BUG #2930: Hash join abyssmal with many null fields.
- References:
- BUG #2930: Hash join abyssmal with many null fields.
- From: Maciej Babinski
- BUG #2930: Hash join abyssmal with many null fields.
- Prev by Date: BUG #2934: INSTALL FAILURE - failed to set permissions on the installed files
- Next by Date: Re: BUG #2930: Hash join abyssmal with many null fields.
- Previous by thread: BUG #2930: Hash join abyssmal with many null fields.
- Next by thread: Re: BUG #2930: Hash join abyssmal with many null fields.
- Indexes: