For example, if I set ON DELETE CASCADE, can it somehow affect performance outside delete command? Or will it only affect performance when deleting?
And more importantly - if I set to do nothing on delete (eg no delete constraint), will postgres do any special validations when selecting from that table that could impact performance, or am I only risking getting corrupted data?
Thanks!