Re: CONNECT BY PRIOR

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Yann Michel <yann-postgresql(at)spline(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: CONNECT BY PRIOR
Date: 2005-11-15 06:38:31
Message-ID: 36e682920511142238of06f2ao5ff67a6a5df62cb3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hey Simon,
I'm doing some research into recursive query planning in terms of theory
as-well-as actual implementation in other RDBMS. Let me get back to you when
I have some more definitive info.

On 11/14/05, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>
> On Sat, 2005-11-12 at 15:27 -0500, Jonah H. Harris wrote:
>
> > I am working on the standard WITH syntax for recursive query support
> > and hope to get it into 8.2.
>
> Sounds interesting.
>
> What approach are you taking to the plan shape? The current approach
> would be to have additional plan nodes for each join. Coping with a
> dynamic number of operations will do interesting things in the planner.
>
> I face a similar dynamic problem with joins to partitioned tables.
>
> Do you have any thoughts about this area?
>
> Best Regards, Simon Riggs
>
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Glaesemann 2005-11-15 06:51:24 Re: Long-time 7.4 contrib failure Mac OS X 10.3.8
Previous Message Jonah H. Harris 2005-11-15 06:28:12 Re: [HACKERS] Major Problem, need help! Can't run our