3 ms·
Adding a foreign key to a massive table can take a long time, since all existing row data must be validated against the constraint. With logical replication, lo
by evanelias 7y ago
Adding a foreign key to a massive table can take a long time, since all existing row data must be validated against the constraint. With logical replication, long operations like this can be quite disruptive, even with a multi-threaded logical replication scheme.