diff options
| author | Simon Riggs | 2018-03-27 18:57:02 +0000 |
|---|---|---|
| committer | Simon Riggs | 2018-03-27 18:57:02 +0000 |
| commit | c203d6cf81b4d7e43edb2b75ec1b741ba48e04e0 (patch) | |
| tree | cf9e4a14290ef99232a5f5f477d5b2672df57629 /contrib/jsonb_plpython | |
| parent | 1944cdc98273dbb8439ad9b387ca2858531afcf0 (diff) | |
Allow HOT updates for some expression indexes
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
Diffstat (limited to 'contrib/jsonb_plpython')
0 files changed, 0 insertions, 0 deletions