Re: Early Sort/Group resjunk column elimination.

2021-07-20 Thread Ronan Dunklau
Le vendredi 16 juillet 2021, 17:37:15 CEST James Coleman a écrit : > Thanks for hacking on this; as you're not surprised given I made the > original suggestion, I'm particularly interested in this for > incremental sort benefits, but I find the other examples you gave > compelling also. > > Of cou

Re: Early Sort/Group resjunk column elimination.

2021-07-16 Thread James Coleman
On Tue, Jul 13, 2021 at 10:19 AM Ronan Dunklau wrote: > > Hello, > > I would like to know if there is any interest in working to reduce the usage > and propagation of resjunk columns in the planner. > > I think this topic is worth investigating, because most of the time when we > request a sorted

Early Sort/Group resjunk column elimination.

2021-07-13 Thread Ronan Dunklau
Hello, I would like to know if there is any interest in working to reduce the usage and propagation of resjunk columns in the planner. I think this topic is worth investigating, because most of the time when we request a sorted path without ever needing the sort key afterwards, we still carry