Zhang Mingli

> Nestloop tends to use normal plan instead of Parallel, need a dig. ENV problem, corrected. And I have to clarify that even without Broadcast, Redistribute both side(in parallel-oblivious plan)...

> This commit [9e6035c](https://github.com/cloudberrydb/cloudberrydb/commit/9e6035c5fefcbcd94be16b28935e91ba7c4bc339) describes very clear that it is only for extension compatibility sake. Yeah, my question is > Why GPDB/CBDB doesn't use enable_geqo unlike Postgres, shall we use...

The geo related GUCs are ignored since Greenplum init commit, we don't know the concern behind that , and if it's still a concern now. I'm thinking of getting GUCs...

> > I'm thinking of getting GUCs like `enable_geqo` back in planner codes. > > totally agree The challenges are: It will introduce plan diffs for ICW. And.. Genetic Algorithm...

Succeed to Make install, but the output said sth bad happened, only me?

Many plan diffs, will fix later.

> For query which has Aggregation but without Group by clause, the DISTINCT/DISTINCT ON/ORDER BY clause could be removed as there would be one row returned at most. SRF will...

> I took a look at orca, it has already optimized `distinct` function. > > ``` > explain select distinct(count(a)) from foo; > QUERY PLAN > ------------------------------------------------------------------------------------ > Finalize Aggregate...

> Orca removed the distinct expression when it is used on the agg expression even if there is group by clause, do we need to consider that? We can consider...

Many thanks @fanfuxiaoran for detailed review!