aeschbacherEUF
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...
 that will speed the count distinct but for a lot of other queries we would need to have optimizer set to on