update behavior - Mailing list pgsql-admin

From Scott Ribe
Subject update behavior
Date
Msg-id 75F792AF-58DF-4559-A2E8-C89060D1E94E@elevated-dev.com
Whole thread Raw
Responses Re: update behavior
Re: update behavior
List pgsql-admin
I believe that if I UPDATE a row with the same values that it already has, this still dirties pages, writes the row,
generatesa WAL entry. There is no shortcut in the processing that's "hey, there's not really a change here, we'll just
leavestorage alone". 

Is this correct?

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/






pgsql-admin by date:

Previous
From: akshay polji
Date:
Subject: Re: alter the datatype of Partition Key
Next
From: "David G. Johnston"
Date:
Subject: Re: update behavior