Horton

Push index operator lossiness determination down to GIST/GIN opclass

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 9b5c8d45f62bd3d243a40cc84deb93893f2f5122
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2008-04-14T17:05:34Z
Releases: 8.4.0 
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.

Files

PathChange+/−
contrib/btree_gist/btree_bit.c modified +6 −1
contrib/btree_gist/btree_bytea.c modified +6 −1
contrib/btree_gist/btree_cash.c modified +6 −1
contrib/btree_gist/btree_date.c modified +6 −1
contrib/btree_gist/btree_float4.c modified +6 −1
contrib/btree_gist/btree_float8.c modified +6 −2
contrib/btree_gist/btree_gist.sql.in modified +58 −58
contrib/btree_gist/btree_inet.c modified +5 −0
contrib/btree_gist/btree_int2.c modified +6 −1
contrib/btree_gist/btree_int4.c modified +6 −2
contrib/btree_gist/btree_int8.c modified +6 −1
contrib/btree_gist/btree_interval.c modified +6 −1
contrib/btree_gist/btree_macaddr.c modified +6 −2
contrib/btree_gist/btree_numeric.c modified +6 −2
contrib/btree_gist/btree_oid.c modified +6 −2
contrib/btree_gist/btree_text.c modified +14 −4
contrib/btree_gist/btree_time.c modified +11 −3
contrib/btree_gist/btree_ts.c modified +12 −2
contrib/btree_gist/uninstall_btree_gist.sql modified +21 −21
contrib/cube/cube.c modified +6 −1
contrib/cube/cube.sql.in modified +3 −3
contrib/cube/uninstall_cube.sql modified +2 −2
contrib/hstore/hstore_gin.c modified +12 −2
contrib/hstore/hstore_gist.c modified +5 −0
contrib/hstore/hstore.sql.in modified +12 −12
contrib/hstore/uninstall_hstore.sql modified +3 −3
contrib/intarray/_intbig_gist.c modified +5 −0
contrib/intarray/_int_gin.c modified +35 −9
contrib/intarray/_int_gist.c modified +5 −0
contrib/intarray/_int.sql.in modified +18 −18
contrib/intarray/uninstall__int.sql modified +4 −4
contrib/ltree/_ltree_gist.c modified +6 −1
contrib/ltree/ltree_gist.c modified +8 −3
contrib/ltree/ltree.sql.in modified +13 −13
contrib/ltree/uninstall_ltree.sql modified +3 −3
contrib/pg_trgm/pg_trgm.sql.in modified +6 −6
contrib/pg_trgm/trgm_gin.c modified +6 −1
contrib/pg_trgm/trgm_gist.c modified +11 −4
contrib/pg_trgm/uninstall_pg_trgm.sql modified +3 −3
contrib/seg/seg.c modified +11 −2
contrib/seg/seg.sql.in modified +3 −3
contrib/seg/uninstall_seg.sql modified +2 −2
contrib/tsearch2/tsearch2.sql.in modified +8 −8
doc/src/sgml/catalogs.sgml modified +1 −8
doc/src/sgml/func.sgml modified +2 −2
doc/src/sgml/gin.sgml modified +7 −4
doc/src/sgml/gist.sgml modified +5 −2
doc/src/sgml/indexam.sgml modified +10 −10
doc/src/sgml/ref/alter_opfamily.sgml modified +10 −14
doc/src/sgml/ref/create_opclass.sgml modified +13 −17
doc/src/sgml/textsearch.sgml modified +7 −65
doc/src/sgml/xindex.sgml modified +15 −10
src/backend/access/gin/ginarrayproc.c modified +34 −7
src/backend/access/gin/ginget.c modified +42 −25
src/backend/access/gist/gistget.c modified +22 −11
src/backend/access/gist/gistproc.c modified +18 −3
src/backend/commands/opclasscmds.c modified +1 −5
src/backend/nodes/copyfuncs.c modified +1 −2
src/backend/nodes/equalfuncs.c modified +1 −2
src/backend/parser/gram.y modified +9 −4
src/backend/utils/adt/tsginidx.c modified +12 −8
src/backend/utils/adt/tsgistidx.c modified +9 −4
src/backend/utils/adt/tsquery_gist.c modified +7 −2
src/bin/pg_dump/pg_dump.c modified +43 −3
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/pg_amop.h modified +351 −353
src/include/catalog/pg_proc.h modified +8 −8
src/include/nodes/parsenodes.h modified +1 −2