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