aeschbacherEUF

Results 3 comments of aeschbacherEUF

Hi Team, Eddie provided us with a test RPM package containing the single fix for issue #676 (already cherry-picked and built into v1.6.0): [Implement 3-phase aggregation with DEDUP HashAgg for...

`set gp_eager_distinct_dedup = on; set optimizer = on; set optimizer_enable_multiple_distinct_aggs = off; explain (analyze, verbose, costs, timing, buffers) select count(distinct gsp_id) from eft_com_call_statistic;` QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------- Finalize Aggregate (cost=0.00..1252.01 rows=1...

![image](https://github.com/user-attachments/assets/a947151c-4f2f-4e94-a3de-c9c7b98215a7) that will speed the count distinct but for a lot of other queries we would need to have optimizer set to on