11.7. Indexes on Expressions

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: clowder(at)hey(dot)com
Subject: 11.7. Indexes on Expressions
Date: 2021-12-16 16:57:37
Message-ID: 163967385701.26064.15365003480975321072@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2021-12-16 20:52:32 Re: 11.7. Indexes on Expressions
Previous Message Jonathan S. Katz 2021-12-14 19:07:54 Re: bad style for SECURITY DEFINER