Re: [HACKERS] Hash Join Optimization

2008-03-30 Thread Gokulakannan Somasundaram
On Fri, Mar 28, 2008 at 2:04 PM, ITAGAKI Takahiro [EMAIL PROTECTED] wrote: Gokulakannan Somasundaram [EMAIL PROTECTED] wrote: 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

Re: [HACKERS] Hash Join Optimization

2008-03-28 Thread ITAGAKI Takahiro
Gokulakannan Somasundaram [EMAIL PROTECTED] wrote: 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. Many implementations of mem-map disallow to extend the sizes. Do you have

[HACKERS] Hash Join Optimization

2008-03-25 Thread Gokulakannan Somasundaram
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