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.
--
Best regards,
Aleksander Alekseev
