2011/5/24 Tom Lane <t...@sss.pgh.pa.us>: > Robert Haas <robertmh...@gmail.com> writes: > Yeah. I fixed the executor in 9.1, but got hung up on how to fix the > planner. So the planner still only knows how to do this for the case of > an inner indexscan, ie, it can't handle parameterizing any piece of a > plan larger than a single indexscan. I have some ideas about fixing > that but have had no time to pursue them since December :-(
If you can afford, could you describe the ideas? Or I'm glad if you tell where to start looking. Anyway I'm going to dig into optimizer more by myself. > But I'm not sure > whether the same argument can be made for arbitrary subqueries. I guess it's hard to apply the mechanism to arbitrary subqueries, but there are many use cases like my example, Agg node in inner. Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
