Re: make add_paths_to_append_rel aware of startup cost - Mailing list pgsql-hackers

From Andy Fan
Subject Re: make add_paths_to_append_rel aware of startup cost
Date
Msg-id CAKU4AWqaTNPrYcb_cMEDDYWZVGfFxuUjr75F5LBZwnUQ0JvVPw@mail.gmail.com
Whole thread Raw
In response to Re: make add_paths_to_append_rel aware of startup cost  (Andy Fan <zhihui.fan1213@gmail.com>)
Responses Re: make add_paths_to_append_rel aware of startup cost
List pgsql-hackers
Hi,
 
What do you think about this in my last reply?  "If my above 
analysis is correct,  I think the best way to  handle this is if there 
is no more tables to join, we use cheapest  fraction cost for all 
the kinds of relations,  including plain relation,  append rel, 
subquery and so on, If we have more tables to join,  we use
cheapest startup cost.".  This is what is in my mind now. 

 
Here is an updated version to show what's in my mind. 

--
Best Regards
Andy Fan
Attachment

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Sync scan & regression tests
Next
From: Heikki Linnakangas
Date:
Subject: Fix GIST readme on LSN vs NSN