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