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