On 27 May 2017 01:03, "Aleksander Alekseev" <a.aleks...@postgrespro.ru> wrote:
Hi Konstantin, > May be it is possible to somehow optimize it, by checking ranges of primary > key values It's possible. An optimization you are looking for is called Merkle tree . Particularly it's used in Riak .  https://en.wikipedia.org/wiki/Merkle_tree  http://docs.basho.com/riak/kv/2.2.3/learn/concepts/active-anti-entropy/ Personally I'd very much value a solid, standalone resynchronization function implemented in C using a PGconn. Even better if it could report differences and/or apply local changes.