• Tom Lane's avatar
    Cache the result of makesign() across calls of gtrgm_penalty(). · 0a5d5a49
    Tom Lane authored
    Since gtrgm_penalty() is usually called many times in a row with the same
    "newval" (to determine which item on an index page newval fits into best),
    the makesign() calculation is repetitious.  It's expensive enough to make
    it worth caching the result, so do so.  On my machine this is good for
    more than a 40% savings in the time needed to build a trigram index on
    /usr/share/dict/words.  This is all per a suggestion of Heikki's.
    
    In passing, make some mostly-cosmetic improvements in the caching logic in
    the other functions in this file that rely on caching info in fn_extra.
    0a5d5a49
trgm_gist.c 19 KB