Postgres Index and Updates - Mailing list pgsql-general

From Navindren Baskaran
Subject Postgres Index and Updates
Date
Msg-id CABNOo1aGiNac1NzodpnQ4VPwvPH0=F9+dMidJrx3d0v4fyBHLg@mail.gmail.com
Whole thread Raw
Responses Re: Postgres Index and Updates
List pgsql-general
Hello,

We would like to understand in which scenario an index on a table will be rebuilt. Example if we have a table, which has two columns and one if it is indexed, which of the below operation trigger an index rebuild:

1. updating the value of the indexed column.
2. updating the value of the non-indexed column.

Thank you

pgsql-general by date:

Previous
From: Arthur Ramsey
Date:
Subject: Re: Failed upgrade from 12.11 to 14.4
Next
From: Laurenz Albe
Date:
Subject: Re: Postgres Index and Updates