Re: [HACKERS] btree_gin and BETWEEN

2015-06-23 Thread Tom Lane
Jeff Janes writes: > If I use the btree_gin extension to build a gin index on a scalar value, it > doesn't work well with BETWEEN queries. It looks like it scans the whole > index, with the part of the index between the endpoints getting scanned > twice. It is basically executed as if "col1 betw

[HACKERS] btree_gin and BETWEEN

2015-06-23 Thread Jeff Janes
If I use the btree_gin extension to build a gin index on a scalar value, it doesn't work well with BETWEEN queries. It looks like it scans the whole index, with the part of the index between the endpoints getting scanned twice. It is basically executed as if "col1 between x and y" were "col1 betw