diff options
| author | Bruce Momjian <bruce@momjian.us> | 2021-12-22 16:29:16 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2021-12-22 16:29:16 -0500 |
| commit | 8f22fe2025bf97bc2bd6e0a7b3acf97ab970a4e2 (patch) | |
| tree | 665b6c75925fee9732cdca2b38d871c1f9d5b21a | |
| parent | 9edca4cb57d240a196403c805dfa92686954d155 (diff) | |
doc: clarify when expression indexes evaluate their expressions
Only non-HOT updates evaluate the index expression.
Reported-by: Chris Lowder
Discussion: https://postgr.es/m/163967385701.26064.15365003480975321072@wrigleys.postgresql.org
Backpatch-through: 10
| -rw-r--r-- | doc/src/sgml/indices.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 3d5325de916..8a9beae7b43 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -725,8 +725,8 @@ CREATE INDEX people_names ON people ((first_name || ' ' || last_name)); <para> Index expressions are relatively expensive to maintain, because the - derived expression(s) must be computed for each row upon insertion - and whenever it is updated. However, the index expressions are + derived expression(s) must be computed for each row insertion + and non-HOT update. However, the index expressions are <emphasis>not</> recomputed during an indexed search, since they are already stored in the index. In both examples above, the system sees the query as just <literal>WHERE indexedcolumn = 'constant'</> |