Hi,<br /> I had a chance to go through the Hash join code of Postgresql and had the following thoughts.<br /><br />-
Currentlypostgres takes the heaptuple from the slot and creates and minimal_tuple and copies it into the temp file.<br
/><br/>I think the creation of minimal_tuple in the middle is a overhead which can be avoided by creating a mem-map and
directlycreating the minimal_tuple in the mem-map. Since Hash join is used mainly to join huge tables, this might
benefitthose warehouse customers of postgres.<br /><br />Am i missing something???<br /><br />Thanks,<br />Gokul.<br />