Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

So then don't do it inside a transaction. It still wouldn't be any less safe than their current approach of just not using FKs at all


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: