On Thu, Jun 19, 2025 at 10:24 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:
> 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?
>
>
Correct. You need a trigger to prevent the update. There is one provided:
suppress_redundant_updates_trigger()
https://www.postgresql.org/docs/17/functions-trigger.html
David J.