Re: make add_paths_to_append_rel aware of startup cost
От | Andy Fan |
---|---|
Тема | Re: make add_paths_to_append_rel aware of startup cost |
Дата | |
Msg-id | CAKU4AWqC5dR6DJ+XYiE+W4YiaokbE-myVgdnvqX3wx_Z87hk+w@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: make add_paths_to_append_rel aware of startup cost (David Rowley <dgrowleyml@gmail.com>) |
Ответы |
Re: make add_paths_to_append_rel aware of startup cost
|
Список | pgsql-hackers |
Hi David,
But overall, I'm more inclined to just go with the more simple "add a
cheap unordered startup append path if considering cheap startup
plans" version. I see your latest patch does both. So, I'd suggest two
patches as I do see the merit in keeping this simple and cheap. If we
can get the first part in and you still find cases where you're not
getting the most appropriate startup plan based on the tuple fraction,
then we can reconsider what extra complexity we should endure in the
code based on the example query where we've demonstrated the planner
is not choosing the best startup path appropriate to the given tuple
fraction.
committed first. Actually I tried a lot to make a test case which can prove
the value of cheapest fractional cost but no gain so far:(
--
Best Regards
Andy Fan
В списке pgsql-hackers по дате отправления: