On Fri, Feb 14, 2025 at 1:02 AM Michał Kłeczek <mic...@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. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support
