Amit Kapila wrote: > I think it is because heap_getattr() is not that cheap. We have > noticed the similar problem during development of scan key push down > work .
One possibility to reduce the cost of that is to use whole tuple deform instead of repeated individual heap_getattr() calls. Since we don't actually need *all* attrs, we can create a version of heap_deform_tuple that takes an attribute number as argument and decodes up to that point. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers