'Updating time of postgres indexes

I was wondering about the performance of indexes in PostgreSQL. I was mining in the web articles trying to figure out how to check the updating time of an index. I thought Postgres could have some direct construct. The scenario is: there are 4 semesters of sales periodically inserted into a table which has an index on the pk column; I would take the time for updating that index in each semester.



Solution 1:[1]

Indexes are always updated automatically, right when you modify the data. There is nothing extra you have to do, and there is nothing you can do to influence that process (for example, suspend index maintenance and do it later).

To preempt comments that criticize “there is nothing you can do to influence that process”: yes, GIN indexes have a “pending list”, whose existence and size you can configure.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Laurenz Albe