Re: Dirty buffers with suppress_redundant_updates_trigger

From: Mike Noordermeer <mike(at)normi(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dirty buffers with suppress_redundant_updates_trigger
Date: 2020-09-14 15:12:16
Message-ID: CAF0ozqvN9bsPNZ-K9nE4eKETi7O1dhm_=wB5Cj5oEmC3DPVQDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For future reference, in the end I have just added a WHERE clause
comparing all fields with IS DISTINCT FROM. This seems to work well,
prevents any locks/WAL-generation and is about as fast as the previous
solution with suppress_redundant_updates_trigger().

Kind regards,

Mike

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2020-09-14 15:35:40 Re: Dirty buffers with suppress_redundant_updates_trigger
Previous Message luis.roberto 2020-09-14 13:39:26 Effective IO Concurrency