On Fri, Feb 14, 2025 at 1:02 AM Michał Kłeczek <michal@kleczek.org> wrote:
Create index concurrently and then fiddle with the catalog tables to define the constraint using this index?
You mean an ALTER TABLE ... ADD CONSTRAINT ... EXCLUDE without actually doing an ALTER TABLE. Nope, that's far worse than the pg_repack shenanigans, as we would be creating new catalog objects.
Ideally would be that someone adds support for USING INDEX for an exclusion constraint.