Postgres Pro
Downloads
Home   >   mailing lists

Is index rebuilt upon updating table with the same values as already existing in the table? - Mailing list pgsql-general

From Zeev Ben-Sender
Subject Is index rebuilt upon updating table with the same values as already existing in the table?
Date
Msg-id 217DDBC2BB1E394CA9E7446337CBDEF2A8889B1A12@il-ex01.ad.checkpoint.com
Whole thread Raw
Responses Re: Is index rebuilt upon updating table with the same values as already existing in the table?
List pgsql-general
Tree view

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

 

pgsql-general by date:

Previous
From: Selena Deckelmann
Date:
Subject: Seeking Postgres users, DBAs and developers in areas where we don't have conferences or user groups
Next
From: Merlin Moncure
Date:
Subject: Re: ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language..