Chris Hajas

> On Tuesday, August 23, 2022 4:08 PM gpopt wrote: > > > @dgkimura Catalog is a good place to store the info. 7X is fine. How do we deal...

If you set the guc `optimizer_print_optimization_stats=on`, you can see which transforms and the number of bindings/alternatives generated. ``` CXformProject2ComputeScalar: 15 calls, 15 total bindings, 15 alternatives generated, 0ms CXformExpandNAryJoin: 3...

We have a few MDPs that can also be re-enabled (but might need to be regenerated too): search for `DML on partitioned tables` in the code.

> > Analyze/collect stats during exchange, with the assumption that the overhead from analyzing would be much less than the constraint checks that partitions already undergo when exchanged/added. However, in...

> * How is the behavior - does user every-time have to analyze with `optimizer_analyze_always_collect_hll` ordinary table if required to collect this info or its first time only required and...

Thanks for the comments! Closing this PR in favor of adding it as a reloption as suggested by @ashwinstar. That way, we don't need a GUC and it will be...

I took a VERY quick look here, it might be as simple as adding a delimiter to the hash function. This issue only exists on 6X

> Many thanks kainwen! Is there any way to look in tests by ourselves? In 7x branch concourse-ci is open for pr author... We don't currently have 6X CI open...

Fixed in https://github.com/greenplum-db/gpdb/pull/15891

Why are we keeping penalization on by default? Risk? When we don't penalize, do we see any worse plans? Can we add some of that reasoning to the PR