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

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 h

[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 b