HOT update: why must ALL indexes should be update?

From: Daniel Wu <staywithpin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: HOT update: why must ALL indexes should be update?
Date: 2023-04-21 14:06:41
Message-ID: CAPoYtoKY9JSkwxM5BDyameea7gEWw1a0v_8gaZbazsT73YqzVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have many indexes on a table. The chance is that any column could be
some part of an index. I understand that when an index has a column that is
updated, we can't use HOT, because the index entry could point to a totally
different row. But if I have 10 indexes, if only 1 index will be updated,
why the rest 9 indexes couldn't use HOT update?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-04-21 14:19:42 Re: HOT update: why must ALL indexes should be update?
Previous Message Marc Millas 2023-04-21 10:22:52 Re: missing something about json syntax