Push index operator lossiness determination down to GIST/GIN opclass
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 14 Apr 2008 17:05:34 +0000 (17:05 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 14 Apr 2008 17:05:34 +0000 (17:05 +0000)
commita0b3474618d09599f6922f27e467e10ba1f19006
tree673f0b53840d0c0b4ab9e78b0cf75f4b3e9afd87
parent7dc658556892c8e7e95ba47d0acc41f92707a1d9
Push index operator lossiness determination down to GIST/GIN opclass
"consistent" functions, and remove pg_amop.opreqcheck, as per recent
discussion.  The main immediate benefit of this is that we no longer need
8.3's ugly hack of requiring @@@ rather than @@ to test weight-using tsquery
searches on GIN indexes.  In future it should be possible to optimize some
other queries better than is done now, by detecting at runtime whether the
index match is exact or not.

Tom Lane, after an idea of Heikki's, and with some help from Teodor.
68 files changed:
contrib/btree_gist/btree_bit.c
contrib/btree_gist/btree_bytea.c
contrib/btree_gist/btree_cash.c
contrib/btree_gist/btree_date.c
contrib/btree_gist/btree_float4.c
contrib/btree_gist/btree_float8.c
contrib/btree_gist/btree_gist.sql.in
contrib/btree_gist/btree_inet.c
contrib/btree_gist/btree_int2.c
contrib/btree_gist/btree_int4.c
contrib/btree_gist/btree_int8.c
contrib/btree_gist/btree_interval.c
contrib/btree_gist/btree_macaddr.c
contrib/btree_gist/btree_numeric.c
contrib/btree_gist/btree_oid.c
contrib/btree_gist/btree_text.c
contrib/btree_gist/btree_time.c
contrib/btree_gist/btree_ts.c
contrib/btree_gist/uninstall_btree_gist.sql
contrib/cube/cube.c
contrib/cube/cube.sql.in
contrib/cube/uninstall_cube.sql
contrib/hstore/hstore.sql.in
contrib/hstore/hstore_gin.c
contrib/hstore/hstore_gist.c
contrib/hstore/uninstall_hstore.sql
contrib/intarray/_int.sql.in
contrib/intarray/_int_gin.c
contrib/intarray/_int_gist.c
contrib/intarray/_intbig_gist.c
contrib/intarray/uninstall__int.sql
contrib/ltree/_ltree_gist.c
contrib/ltree/ltree.sql.in
contrib/ltree/ltree_gist.c
contrib/ltree/uninstall_ltree.sql
contrib/pg_trgm/pg_trgm.sql.in
contrib/pg_trgm/trgm_gin.c
contrib/pg_trgm/trgm_gist.c
contrib/pg_trgm/uninstall_pg_trgm.sql
contrib/seg/seg.c
contrib/seg/seg.sql.in
contrib/seg/uninstall_seg.sql
contrib/tsearch2/tsearch2.sql.in
doc/src/sgml/catalogs.sgml
doc/src/sgml/func.sgml
doc/src/sgml/gin.sgml
doc/src/sgml/gist.sgml
doc/src/sgml/indexam.sgml
doc/src/sgml/ref/alter_opfamily.sgml
doc/src/sgml/ref/create_opclass.sgml
doc/src/sgml/textsearch.sgml
doc/src/sgml/xindex.sgml
src/backend/access/gin/ginarrayproc.c
src/backend/access/gin/ginget.c
src/backend/access/gist/gistget.c
src/backend/access/gist/gistproc.c
src/backend/commands/opclasscmds.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/utils/adt/tsginidx.c
src/backend/utils/adt/tsgistidx.c
src/backend/utils/adt/tsquery_gist.c
src/bin/pg_dump/pg_dump.c
src/include/catalog/catversion.h
src/include/catalog/pg_amop.h
src/include/catalog/pg_proc.h
src/include/nodes/parsenodes.h