On Fri, Feb 24, 2017 at 3:04 PM, Amit Kapila <amit.kapil...@gmail.com> wrote:
Thanks for the comments. > What advantage do you see for considering such a path when the cost of > innerpath is more than cheapest_total_inner? Remember the more paths > we try to consider, the more time we spend in the planner. By any > chance are you able to generate any query where it will give benefit > by considering costlier innerpath? If inner_cheapest_total path is not parallel safe then I am trying to find the cheapest parallel safe path and generate partial merge join. I agree that it will consider one extra path while considering every partial merge join path (I think with this addition we will not get parallel merge path for the any more TPCH query). I feel in general we can get some better plan by this especially when gather is the cheapest path for inner relation(which is not parallel safe) but at the cost of considering some extra paths. What is your thought on this? -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
