Re: [GENERAL] Adding domain type with CHECK constraints slow on large table

Jerry Sievers [EMAIL PROTECTED] writes: I believe what's happening here is that the server doesn't realize that the new column is going to have all nulls and that the check constraint allows nulls. As such, the check evidently is being evaluated for each row of the table. Yup, that's right.

Re: [GENERAL] Adding domain type with CHECK constraints slow on large table

Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: I believe what's happening here is that the server doesn't realize that the new column is going to have all nulls and that the check constraint allows nulls. As such, the check evidently is being evaluated for