On Jan 24, 2016, at 8:17 PM, Christophe Pettus <xof@thebuild.com> wrote:
> 2. Use the NOT VALID option on ALTER TABLE ... ADD constraint, which allows the addition of a constraint without
actuallychecking its validity.
And note that you might miss some potential planner optimizations this way, as the planner will not assume the
constraintholds true unless you remove the NOT VALID condition from it with VALIDATE CONSTRAINT.
--
-- Christophe Pettus
xof@thebuild.com