Re: [GENERAL] Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains

2016-09-21 Thread Jeff Janes
On Wed, Sep 21, 2016 at 2:18 PM, pinker wrote: > Jeff Janes wrote > > Try swapping the order of the columns in the exclude constraint. You > want > > the more selective criterion to appear first in the index/constraint. > > Presumably "key with =" is the most selective, especially if many of you

[GENERAL] Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains

2016-09-21 Thread pinker
Jeff Janes wrote > Try swapping the order of the columns in the exclude constraint. You want > the more selective criterion to appear first in the index/constraint. > Presumably "key with =" is the most selective, especially if many of your > periods are unbounded. I would not be so sure with tha