With DEFERRABLE INITIALLY IMMEDIATE you can defer the constraints on demand when you need it.
This is useful if you normally want to check the constraints at statement time, but for e.g. a batch load want to defer the checking until commit time.
The syntax how to defer the constraints is different for the various DBMS though.
With NOT DEFERRABLE you will never ever be able to defer the checking until commit time.