• Tom Lane's avatar
    Remove <@ from contrib/intarray's GiST operator classes. · 20e7e1fe
    Tom Lane authored
    Since commit efc77cf5, an indexed query using <@ has required a
    full-index scan, so that it actually performs worse than a plain seqscan
    would do.  As I noted at the time, we'd be better off to not treat <@ as
    being indexable by such indexes at all; and that's what this patch does.
    
    It would have been difficult to remove these opclass members without
    dropping the whole opclass before commit 9f968278 fixed GiST opclass
    member dependency rules, but now it's quite simple, so let's do it.
    
    I left the existing support code in place for the time being, with
    comments noting it's now unreachable.  At some point, perhaps we should
    remove that code in favor of throwing an error telling people to upgrade
    the extension version.
    
    Discussion: https://postgr.es/m/2176979.1596389859@sss.pgh.pa.us
    Discussion: https://postgr.es/m/458.1565114141@sss.pgh.pa.us
    20e7e1fe
_intbig_gist.c 12 KB