No — most constraint checks are by default deferred until the end of the transaction, but you'd still need to check them, and without an index you'll still have

No — most constraint checks are by default deferred until the end of the transaction, but you'd still need to check them, and without an index you'll still have to do a large scan. See https://www.postgresql.org/docs/17/sql-set-constraints.html https://www.postgresql.org/docs/17/sql-set-constraints.html for more information regarding constraint checking.