2 ms·
> In more recent versions there's "logical replication", which sort of "sends the queries" What it sends is not the queries, but a logical description of the c
by amenonsen 6y ago
> In more recent versions there's "logical replication", which sort of "sends the queries"
What it sends is not the queries, but a logical description of the changes to each row that were made by running the query. So an UPDATE that changes N rows would generate N changes to be applied to the corresponding rows (usually identified by primary key) on the logical replica, not a single update that had to be "re-executed".