Re: exponential time growth of handling subqueries - Mailing list pgsql-hackers

From Tom Lane
Subject Re: exponential time growth of handling subqueries
Date
Msg-id 3632.1066089058@sss.pgh.pa.us
Whole thread Raw
In response to exponential time growth of handling subqueries  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> This is sort of interesting. It seems the time required for the optimizer to
> handle a query doubles with every layer of subquery it has to dig through.

Seems to be due to some brain fade in pull_up_subqueries --- the thing
was constructing truly monstrous rangetables due to poorly thought out
recursive modification of the parse tree :-(.  Patch applied in CVS tip.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Heading to final release
Next
From: Rod Taylor
Date:
Subject: Re: Heading to final release