On Mon, 14 Sep 2020 at 06:32, Mike Noordermeer <mike(at)normi(dot)net> 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