jiaqizho commented on PR #776: URL: https://github.com/apache/cloudberry/pull/776#issuecomment-2544621178
> Just tried, but cannot produce 3-stage aggregate still, the cost is still higher than 2-stage aggregate. > > ``` > Group 9 (#GExprs: 8): > 0: CLogicalGbAgg( Global ) Grp Cols: [][Global], Minimal Grp Cols: [], Generates Duplicates :[ 0 ] [ 0 8 ] > 1: CLogicalGbAgg( Global ) Grp Cols: [][Global], Minimal Grp Cols: [], Generates Duplicates :[ 0 ] , m_aggStage :[ Three Stage Scalar DQA ] [ 12 15 ] > 2: CLogicalGbAgg( Global ) Grp Cols: [][Global], Minimal Grp Cols: [], Generates Duplicates :[ 0 ] , m_aggStage :[ Two Stage Scalar DQA ] [ 16 15 ] > 3: CLogicalGbAgg( Global ) Grp Cols: [][Global], Minimal Grp Cols: [], Generates Duplicates :[ 0 ] , m_aggStage :[ Two Stage Scalar DQA ] [ 20 25 ] > 4: CPhysicalScalarAgg( Global, multi-stage ) Grp Cols: [], Minimal Grp Cols:[], Generates Duplicates :[ 0 ] , m_aggStage :[ Two Stage Scalar DQA ] [ 20 25 ] > Cost Ctxts: > main ctxt (stage 0)0.1, child ctxts:[0], rows:1.000000 (group), cost: 566.388669 > 5: CPhysicalScalarAgg( Global, multi-stage ) Grp Cols: [], Minimal Grp Cols:[], Generates Duplicates :[ 0 ] , m_aggStage :[ Two Stage Scalar DQA ] [ 16 15 ] > Cost Ctxts: > main ctxt (stage 0)0.1, child ctxts:[0], rows:1.000000 (group), cost: 1090.678248 > 6: CPhysicalScalarAgg( Global, multi-stage ) Grp Cols: [], Minimal Grp Cols:[], Generates Duplicates :[ 0 ] , m_aggStage :[ Three Stage Scalar DQA ] [ 12 15 ] > Cost Ctxts: > 7: CPhysicalScalarAgg( Global ) Grp Cols: [], Minimal Grp Cols:[], Generates Duplicates :[ 0 ] [ 0 8 ] > Cost Ctxts: > main ctxt (stage 0)0.1, child ctxts:[0], rows:1.000000 (group), cost: 765.687983 > Grp OptCtxts: > 0 (stage 0): (req CTEs: [], req order: [<empty> match: satisfy ], req dist: [SINGLETON (master) match: satisfy], req rewind: [], req rewind: [NONE NO-MOTION match: satisfy], req partition propagation: [<empty> match: satisfy ]) => Best Expr:4 > ``` also need running with GUC `optimizer_force_three_stage_scalar_dqa`/`optimizer_force_multistage_agg`. updated the test cases... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
