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
