Re: [GENERAL] Build exclusion constraints USING INDEX

2017-02-10 Thread Steven Winfield
> I was wondering if there was any way to break down the creation of a new > exclusion constraint into stages such that table locks most likely to affect > performance during production hours are not taken. > > Something like: > > CREATE INDEX CONCURRENTLY new_index ON my_table USING gist (column

[GENERAL] Build exclusion constraints USING INDEX

2017-02-07 Thread Steven Winfield
Hi, I was wondering if there was any way to break down the creation of a new exclusion constraint into stages such that table locks most likely to affect performance during production hours are not taken. Something like: CREATE INDEX CONCURRENTLY new_index ON my_table USING gist (column1, colu