Re: [HACKERS] Expression Pruning in postgress

2011-07-13 Thread HarmeekSingh Bedi
will either references or generate an expression. Any expression that is generated and is not referenced by any top on top will be eliminated. Regards Harmeek On Sun, Jul 10, 2011 at 10:28 AM, Tom Lane t...@sss.pgh.pa.us wrote: HarmeekSingh Bedi harmeeksi...@gmail.com writes: Thanks Tom

Re: [HACKERS] Expression Pruning in postgress

2011-07-10 Thread HarmeekSingh Bedi
wrote: HarmeekSingh Bedi harmeeksi...@gmail.com writes: In a plan where Node 1 is parent {say join) and Node 2 is child (say scan) . If node 1 has a expression say foo(column) then scan will project 'column' for sure and join will evaluate foo(column). Now if the node above join does

[HACKERS] Expression Pruning in postgress

2011-07-07 Thread HarmeekSingh Bedi
Hi . Apology for the bandwith. Did not know who to ask the question . I was interested in a brief detail on how postgress does expression pruning between nodes . The basic question is as follows Scenerio In a plan where Node 1 is parent {say join) and Node 2 is child (say scan) . If node

[HACKERS] Question.

2006-12-16 Thread HarmeekSingh Bedi
Hi All. I just looked this email from postgress sql site and wanted to ask you a question. I would be obliged if you could help me understand the duplicate key insertion behaviour correctly in Post gress SQL. The question is related to Btree [Leman and Yao] implementation When