Andres Freund <and...@anarazel.de> writes: > On 2017-03-15 18:16:57 -0400, Tom Lane wrote: >> [ scratches head... ] What deforming logic do you think I'm proposing >> removing?
> I thought you were suggesting that we don't do the get_last_attnums (and > inlined version in the isSimpleVar case) at execution time anymore, > instead relying on logic in the planner to know how much to deform ahead > of time. Then we'd do slot_getsomeattrs in the appropriate places. But > I understood you suggesting to do so only in scan nodes - which doesn't > seem sufficient, due to the use of materialized / minimal tuples in > other types of nodes. Did I misunderstand? We would need to do it anywhere that we might be projecting from a materialized tuple, I suppose. From the planner's standpoint it would be about as easy to do this for all plan nodes as only selected ones. Anyway the core point here seems to be that skipping ExecProject misses a bet because the underlying tuple doesn't get disassembled. A quick-hack way of seeing if this helps might be to do slot_getallattrs in the places where we skip ExecProject. I'm not sure we'd want that as a permanent solution, because it's possible that it extracts columns not actually needed, but it should at least move the hotspot in your example case. regards, tom lane -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers