Koen De Groote <kdg.dev@gmail.com> writes:
>> 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".
It's basically whatever the cost of evaluating that expression is,
plus the normal costs of index insertion. If the expression is
something built-in like sin(x), probably the evaluation cost is
negligible ... but with a user-defined function in SQL or some PL,
maybe not so much.
In any case, the real question is "how many expression evaluations am I
going to save over the life of the row, versus how many I pay up-front?"
You didn't address how many queries would benefit from having the index,
so the question is unanswerable with just these facts.
regards, tom lane
