Thread: Patch: New Plan Node Type support in pg 8.4

Patch: New Plan Node Type support in pg 8.4

From
Ashesh Vashi
Date:
Hi All,

Description of the problem on which, I was working on:
*
New plan node types. There are some new node types in 8.4.
The graphical explain tool needs to learn about these, plus
we need new icons for them.
The new plan nodes are:
- Recursive Union
- Nested Loop Semi Join
- Nested Loop Anti Join
- Merge Semi Join
- Merge Anti Join
- Hash Semi Join
- Hash Anti Join
- CTE Scan
- WorkTable Scan
- HashSetOp Intersect
- HashSetOp Intersect All
- HashSetOp Except
- HashSetOp Except All
- HashSetOp ???
- WindowAgg

Please find the patch for that.
I have tried to draw icons for these node-types, but I find myself
a very bad artist. :p

I have also attached the queries, which I have used to test this.

--
Regards,
Ashesh Vashi

EnterpriseDB INDIA: http://www.enterprisedb.com

Re: Patch: New Plan Node Type support in pg 8.4

From
"Dave Page"
Date:
Thanks - patch applied. I'm also trying to source some new icons.

On Thu, Jan 1, 2009 at 10:18 AM, Ashesh Vashi
<ashesh.vashi@enterprisedb.com> wrote:
> Hi All,
>
> Description of the problem on which, I was working on:
> * New plan node types. There are some new node types in 8.4.
> The graphical explain tool needs to learn about these, plus
> we need new icons for them.
> The new plan nodes are:
> - Recursive Union
> - Nested Loop Semi Join
> - Nested Loop Anti Join
> - Merge Semi Join
> - Merge Anti Join
> - Hash Semi Join
> - Hash Anti Join
> - CTE Scan
> - WorkTable Scan
> - HashSetOp Intersect
> - HashSetOp Intersect All
> - HashSetOp Except
> - HashSetOp Except All
> - HashSetOp ???
> - WindowAgg
>
> Please find the patch for that.
> I have tried to draw icons for these node-types, but I find myself
> a very bad artist. :p
>
> I have also attached the queries, which I have used to test this.
>
> --
> Regards,
> Ashesh Vashi
>
> EnterpriseDB INDIA: http://www.enterprisedb.com
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>
>



--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com