Re: Clarification on Expression indexes

2020-06-16 Thread Tom Lane
Koen De Groote 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 th

Clarification on Expression indexes

2020-06-16 Thread Koen De Groote
Greetings all. The following page: https://www.postgresql.org/docs/11/indexes-expressional.html 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