Clarification on Expression indexes

Поиск
Список
Период
Сортировка
От Koen De Groote
Тема Clarification on Expression indexes
Дата
Msg-id CAGbX52GGzhBk+QtR8MeC_-rA=1ots=oCCAxQPouO84rQjDhfUA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Clarification on Expression indexes
Список 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 по дате отправления:

Предыдущее
От: Eugene Pazhitnov
Дата:
Сообщение: Re: pg_repack: WARNING: relation must have a primary key or not-nullunique keys
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Clarification on Expression indexes