On Mon, 14 Sep 2020 at 06:32, Mike Noordermeer <mike@xxxxxxxxx> wrote: > So it seems > suppress_redundant_updates_trigger() does not entirely avoid writing > _something_ to the blocks, and I don't know what it is and how to > avoid it. Looking at the pg_waldump output, it seems to write something concerning locking to the WAL, I am seeing lots of the following records: rmgr: Heap len (rec/tot): 54/ 54, tx: 6747, lsn: B/BC7785F0, prev B/BC7785B8, desc: LOCK off 36: xid 6747: flags 0x00 LOCK_ONLY EXCL_LOCK , blkref #0: rel 1663/13408/45636 blk 8332 Still trying to figure out what this means... Kind regards, Mike
