Re: update with no changes

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: update with no changes
Date: 2021-11-20 15:03:26
Message-ID: CAB-JLwYwbv0SwoqWW+ytRSCvOKnN5esxnKEsTwqaER9e+J6JqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> suppress_redundant_updates_trigger was created precisely because it's
> not always easy to create application code in such a way that it
> generates no redundant updates. However, there is a cost to using it,
> and the break even point can be surprisingly high. It should therefore
> be used with caution, and after appropriate benchmarks.
>
> well, there is a cost of not using it too. If lots of things needs to be
done when a record is stored, and if it doesn´t needed to be stored, all
these things will not be done. So, what are pros of changing a record
which did not changed any value and what are cons of it ? So, I understood
the way it works and yes, my point of view is that this trigger is really
needed, for me, obviously.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2021-11-20 15:19:08 Re: update with no changes
Previous Message Andrew Dunstan 2021-11-20 14:41:21 Re: update with no changes