On 2015-02-22 09:58:31 -0500, Tom Lane wrote: > Andres Freund <and...@2ndquadrant.com> writes: > > I've wondered before if we shouldn't use the caching via > > slot->tts_values so freely - if you only use a couple values from a wide > > tuple the current implementation really sucks if those few aren't at the > > beginning of the tuple. > > Don't see how you expect to get a win that way. Visiting column k > requires crawling over columns 1..k-1 in practically all cases. > You could maybe save a cycle or so by omitting the physical store > into the Datum array, assuming that you never did need the column > value later ... but the extra bookkeeping for more complicated > tracking of which columns had been extracted would eat that savings > handily.
Depends a bit on the specifics. In this case attcacheoff would allow you direct access, which surely is going to be more efficient. I'm not sure how frequent that happens in practice. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
