Clarification on Expression indexes - Mailing list pgsql-general

From Koen De Groote
Subject Clarification on Expression indexes
Date
Msg-id CAGbX52GGzhBk+QtR8MeC_-rA=1ots=oCCAxQPouO84rQjDhfUA@mail.gmail.com
Whole thread Raw
Responses Re: Clarification on Expression indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Greetings all.


States the following:

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

I'd like to get an idea on "relatively expensive". For instance, compared to a partial index, which is split on one or more boolean values. As opposed to making a function for this that serves the same identical calculation.

Let's say that over the lifetime of a row, it rarely gets updated more than 2000 times, and the majority of this is right after creation?

Is this a concern?

Regards,
Koen De Groote


pgsql-general by date:

Previous
From: Eugene Pazhitnov
Date:
Subject: Re: pg_repack: WARNING: relation must have a primary key or not-nullunique keys
Next
From: Tom Lane
Date:
Subject: Re: Clarification on Expression indexes