Quick Links

update behavior

From:	Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To:	Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject:	update behavior
Date:	2025-06-19 17:23:58
Message-ID:	75F792AF-58DF-4559-A2E8-C89060D1E94E@elevated-dev.com
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	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, generates a WAL entry. There is no shortcut in the processing that's "hey, there's not really a change here, we'll just leave storage alone".

Is this correct?

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

Responses

Re: update behavior at 2025-06-19 17:31:59 from David G. Johnston
Re: update behavior at 2025-06-19 17:35:37 from Tom Lane
Re: update behavior at 2025-06-19 17:51:39 from Rui DeSousa
Re: update behavior at 2025-06-19 17:57:20 from Rui DeSousa
Re: update behavior at 2025-06-19 17:58:36 from Scott Ribe

Browse pgsql-admin by date

	From	Date	Subject
Next Message	David G. Johnston	2025-06-19 17:31:59	Re: update behavior
Previous Message	akshay polji	2025-06-19 07:01:51	Re: alter the datatype of Partition Key