I would add a counter point to foreign key constraints, they make deletions and updates a lot more costly [1].

[1] https://shusson.info/post/postgres-experiments-deleting-tabl...