On 5/21/21 8:41 AM, Marc Millas wrote: > 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 > >
