On Thu, Jan 18, 2018 at 6:14 AM, Amit Kapila <amit.kapil...@gmail.com> wrote: > I see your point. OTOH, I think we should have something for testing > purpose as that helps in catching the bugs and makes it easy to write > tests that cover worker part of the code.
This is about the question of whether or not we want to allow parallel_leader_participation to prevent or allow a parallel CREATE INDEX that has 1 parallel worker that does all the sorting, with the leader simply consuming its output without doing any merging (a "degenerate paralllel CREATE INDEX"). It is perhaps only secondarily about the question of ripping out parallel_leader_participation entirely. > Can you please elaborate what part of optimizer are you talking about > where without leader participation partial path will always lose to a > serial sequential scan path? See my remarks to Robert just now. -- Peter Geoghegan
