summaryrefslogtreecommitdiff
path: root/contrib/tsearch/README.tsearch
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-02-07 22:11:43 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-02-07 22:11:43 +0000
commitfe1a9c336290cde8a1dacc56d0161b123fcc18a1 (patch)
tree42fc9f5cddbf18776b5a291cd03b465d1ace54d7 /contrib/tsearch/README.tsearch
parente206ff59467458cd5a9af593c45565641f218a09 (diff)
downloadpostgresql-fe1a9c336290cde8a1dacc56d0161b123fcc18a1.tar.gz
Repair some problems in GIST-index contrib modules. Patch from
Teodor Sigaev <teodor@stack.net>.
Diffstat (limited to 'contrib/tsearch/README.tsearch')
-rw-r--r--contrib/tsearch/README.tsearch21
1 files changed, 2 insertions, 19 deletions
diff --git a/contrib/tsearch/README.tsearch b/contrib/tsearch/README.tsearch
index 96059893fa..c63ae91edd 100644
--- a/contrib/tsearch/README.tsearch
+++ b/contrib/tsearch/README.tsearch
@@ -198,23 +198,6 @@ Don't forget to do
make clean; make; make install
2.
-As it was mentioned above we don't use explicitly ID of lexems
-as in OpenFTS but use hash function (crc32) instead to map lexem to
-integer. Our experiments show that probability of collision is quite small:
-for english text it's about 10**(-6) and 10**(-5) for russian collection.
-Default installation doesn't check for collisions but if your application
-does need to guarantee an exact (no collisions) search, you need
-to update system table to mark index islossy:
-
- update pg_amop set amopreqcheck = true where amopclaid =
- (select oid from pg_opclass where opcname = 'gist_txtidx_ops');
-
-If you don't bother about collisions :
-
- update pg_amop set amopreqcheck = false where amopclaid =
- (select oid from pg_opclass where opcname = 'gist_txtidx_ops');
-
-3.
txtidx doesn't preserve words ordering (this is not critical for searching)
for performance reason, for example:
@@ -224,7 +207,7 @@ test=# select 'page two'::txtidx;
'two' 'page'
(1 row)
-4.
+3.
Indexed access provided by txtidx data type isn't always good
because of internal data structure we use (RD-Tree). Particularly,
queries like '!gist' will be slower than just a sequential scan,
@@ -265,7 +248,7 @@ test=# select querytree( '!gist'::query_txt );
These two queries will be processed by scanning of full index !
Very slow !
-5.
+4.
Following selects produce the same result
select title from titles where titleidx @@ 'patch&gist';