Commit9ac9878

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 parent861095a commit9ac9878Copy full SHA for 9ac9878

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -733,8 +733,8 @@ CREATE INDEX people_names ON people ((first_name \|\| ' ' \|\| last_name));`
`733`	`733`
`734`	`734`	`<para>`
`735`	`735`	`Index expressions are relatively expensive to maintain, because the`
`736`		`- derived expression(s) must be computed for each rowuponinsertion`
`737`		`- andwhenever it is updated. However, the index expressions are`
	`736`	`+ derived expression(s) must be computed for each row insertion`
	`737`	`+ andnon-HOT update. However, the index expressions are`
`738`	`738`	`<emphasis>not</emphasis> recomputed during an indexed search, since they are`
`739`	`739`	`already stored in the index. In both examples above, the system`
`740`	`740`	`sees the query as just <literal>WHERE indexedcolumn = 'constant'</literal>`

Comments

(0)