From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: clowder@hey.com
Subject: 11.7. Indexes on Expressions
Date: Thu, 16 Dec 2021 16:57:37 +0000
Message-ID: <163967385701.26064.15365003480975321072@wrigleys.postgresql.org> (raw)
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 instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, clowder@hey.com
Subject: Re: 11.7. Indexes on Expressions
In-Reply-To: <163967385701.26064.15365003480975321072@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox