Re: Unnecessary calculations in Execproject
От | Matthias van de Meent |
---|---|
Тема | Re: Unnecessary calculations in Execproject |
Дата | |
Msg-id | CAEze2Wh74ToCU+rO-ogCSE5PLcGYqwYXeh_LF6g034ca_Zpo5Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Unnecessary calculations in Execproject (Aleksander Alekseev <aleksander@tigerdata.com>) |
Список | pgsql-hackers |
On Fri, 19 Sept 2025 at 15:59, Aleksander Alekseev <aleksander@tigerdata.com> wrote: > > Hi Zhao, > > Thanks for sharing. > > > I hacked some of the code into my extension to skip these unnecessary operations, > > and the performance will improve by 2%~5%. Then I think that if there is a way > > to remove the nodes corresponding to these redundant operations in the targetlist > > when initializing the execute node, this performance optimization will be applicable > > widely. If this idea can be approved, I can try to write a patch for it. > > Sounds like a promising area of research / improvement. If it improves > performance for certain queries and doesn't cause any performance > degradation for others, I don't see why it wouldn't be approved. > Unfortunately it's hard to tell more without any specific patch on > hands. FYI, this issue has been discussed a few times before over time, more recently with [0] and [1]. Kind regards, Matthias van de Meent Databricks [0] https://postgr.es/m/2ca5865b-4693-40e5-8f78-f3b45d5378fb%40iki.fi [1] https://postgr.es/m/flat/CABSN6Vc0VXr%2B1w%2Bdn0iUJ--LgGUwM6XwBxcXN%2BvF15fMsYE9cg%40mail.gmail.com
В списке pgsql-hackers по дате отправления: