logical replication - Mailing list pgsql-performance

From Marc Millas
Subject logical replication
Date
Msg-id CADX_1aaqJiO1XU1OkXcX2j2KRt3ei97TVuXQiCuMWNFUpdXV_A@mail.gmail.com
Whole thread Raw
Responses Re: logical replication
List pgsql-performance
Hi,

my POC in postgres 12.(important ?)

if I setup 2 postgres clusters, and create a publication in one and a subscription in the other,
and do on the pub an update which does not change the data (updating an existing record with same data) then this (useless) update go through replication.(ie consumes network ressource)

what are ways to avoid this ?
(I thought of a trigger to not execute the useless update, but I dont see how to do this)
any ideas ?

thanks
PS: remarks about the meaning of this are off topic, thanks

Marc MILLAS
Senior Architect
+33607850334

pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: Partition with check constraint with "like"
Next
From: Andrew Dunstan
Date:
Subject: Re: logical replication