The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/indexes-expressional.html
Description:

Regarding the paragraph (_emphasis_ added):

> 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_.

Does the "it" in the above refer to the entire row or just the columns used
in the expression? Does updating any column of a row trigger an update to
all indexes with expressions? 

Thanks in advance for your time and reply.

Cheers,
Chris Lowder

Reply via email to