Commit2ff2099

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 parent420f9ac commit2ff2099Copy full SHA for 2ff2099

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

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

Comments

(0)