Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commite4f7c51

Browse files
committed
doc: clarify when expression indexes evaluate their expressions
Only non-HOT updates evaluate the index expression.Reported-by: Chris LowderDiscussion:https://postgr.es/m/163967385701.26064.15365003480975321072@wrigleys.postgresql.orgBackpatch-through: 10
1 parent28e1e5c commite4f7c51

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

‎doc/src/sgml/indices.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -732,8 +732,8 @@ CREATE INDEX people_names ON people ((first_name || ' ' || last_name));
732732

733733
<para>
734734
Index expressions are relatively expensive to maintain, because the
735-
derived expression(s) must be computed for each rowuponinsertion
736-
andwhenever it is updated. However, the index expressions are
735+
derived expression(s) must be computed for each row insertion
736+
andnon-HOT update. However, the index expressions are
737737
<emphasis>not</emphasis> recomputed during an indexed search, since they are
738738
already stored in the index. In both examples above, the system
739739
sees the query as just <literal>WHERE indexedcolumn = 'constant'</literal>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp