Re: Deduplicate aggregates and transition functions in planner

2020-11-24 Thread Heikki Linnakangas
On 19/11/2020 12:38, Heikki Linnakangas wrote: So barring objections, I'm going to push the attached updated patch that includes the removal of AggrefExprState, and leave CookedAggrefs or other further refactorings for the future. Done. Thanks! - Heikki

Re: Deduplicate aggregates and transition functions in planner

2020-11-19 Thread Heikki Linnakangas
On 29/10/2020 19:48, Andres Freund wrote: On 2020-10-29 10:17:20 +0200, Heikki Linnakangas wrote: On 28/10/2020 21:59, Andres Freund wrote: It wouldn't surprise me to see a small execution time speedup here - I've seen the load of the aggno show up in profiles. I think you'd be hard-pressed t

Re: Deduplicate aggregates and transition functions in planner

2020-10-29 Thread Andres Freund
Hi, On 2020-10-29 10:17:20 +0200, Heikki Linnakangas wrote: > On 28/10/2020 21:59, Andres Freund wrote: > > It wouldn't surprise me to see a small execution time speedup here - > > I've seen the load of the aggno show up in profiles. > > I think you'd be hard-pressed to find a real-life query whe

Re: Deduplicate aggregates and transition functions in planner

2020-10-29 Thread Heikki Linnakangas
On 28/10/2020 21:59, Andres Freund wrote: On 2020-10-28 21:10:41 +0200, Heikki Linnakangas wrote: Currently, ExecInitAgg() performs quite a lot of work, to deduplicate identical Aggrefs, as well as Aggrefs that can share the same transition state. That doesn't really belong in the executor, we s

Re: Deduplicate aggregates and transition functions in planner

2020-10-28 Thread Andres Freund
Hi, On 2020-10-28 21:10:41 +0200, Heikki Linnakangas wrote: > Currently, ExecInitAgg() performs quite a lot of work, to deduplicate > identical Aggrefs, as well as Aggrefs that can share the same transition > state. That doesn't really belong in the executor, we should perform that > work in the p