logical replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux