Is index rebuilt upon updating table with the same values as already existing in the table?

From: Zeev Ben-Sender <zeevb(at)checkpoint(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Is index rebuilt upon updating table with the same values as already existing in the table?
Date: 2011-04-05 15:22:16
Message-ID: 217DDBC2BB1E394CA9E7446337CBDEF2A8889B1A12@il-ex01.ad.checkpoint.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Having the update statement like this:
UPDATE my_table SET (COL1 = '05cf5219-38e6-46b6-a6ac-5bbc3887d16a', COL2 = 28) WHERE COL3 = 35;

Will this statement result indexes rebuild if COL1 and COL2 already equal '05cf5219-38e6-46b6-a6ac-5bbc3887d16a' and 28?

Thank you

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray Stell 2011-04-05 15:26:49 Re: schema access privs
Previous Message Tom Lane 2011-04-05 14:45:01 Re: Why security-definer functions are executable by public by default?