my-ship-it commented on PR #776:
URL: https://github.com/apache/cloudberry/pull/776#issuecomment-2539284394
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
```
--
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]
