• Simon Riggs's avatar
    Allow HOT updates for some expression indexes · c203d6cf
    Simon Riggs authored
    If the value of an index expression is unchanged after UPDATE,
    allow HOT updates where previously we disallowed them, giving
    a significant performance boost in those cases.
    
    Particularly useful for indexes such as JSON->>field where the
    JSON value changes but the indexed value does not.
    
    Submitted as "surjective indexes" patch, now enabled by use
    of new "recheck_on_update" parameter.
    
    Author: Konstantin Knizhnik
    Reviewer: Simon Riggs, with much wordsmithing and some cleanup
    c203d6cf
heapam.c 281 KB