Investigate use of compact in aggregation executor

[kwannoel]

I think to get another datapoint on whether to compact or not we can do the following:

1. Construct a case where selectivity is 100%
2. Compact
3. See what's the overhead via criterion.
4. Can also get precise overhead in a flamegraph + run criterion.

Can use stream hash agg benchmark / streaming fold agg to measure this.

This serves as a baseline for #9148

[st1page]

#9300

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄