Hi folks,
I need to add an exclusion constraint in a large table.
However, I'm worried about the length of time the table will be
blocked for reads and writes while the constraint is being
created.
With other operations, like adding unique indexes, I can create the
index first, concurrently, and then use that existing index to create
the constraint in place. This approach works well for large tables.
But this doesn't look like something I can do with exclusion
constraints, as I can't perform an ALTER TABLE ... USING INDEX ...
It also does not seem like I can add the constraint with a NOT VALID
condition either.
Do you folks have any recommendations for this situation?
I need to add an exclusion constraint in a large table.
However, I'm worried about the length of time the table will be
blocked for reads and writes while the constraint is being
created.
With other operations, like adding unique indexes, I can create the
index first, concurrently, and then use that existing index to create
the constraint in place. This approach works well for large tables.
But this doesn't look like something I can do with exclusion
constraints, as I can't perform an ALTER TABLE ... USING INDEX ...
It also does not seem like I can add the constraint with a NOT VALID
condition either.
Do you folks have any recommendations for this situation?
