TSEARCH2 Thesaurus limitations - Mailing list pgsql-hackers

From Ted Wong
Subject TSEARCH2 Thesaurus limitations
Date
Msg-id JHECKLBOPCCLFNFFCFDOOEOGCMAA.lasvegas344@comcast.net
Whole thread Raw
List pgsql-hackers
Hi,
I'm new to Postgres and would appreciate some help
in understanding what the limitations of TSEARCH2 and
the Thesauri operation.
I'm trying to use the thesaurus as a geo-tagger/coder.
The first part of the problem is to create placename
list with additional information such as state, county
and country names.  But, the returned values are off.
There's less of a problem when the thesaurus is small
under 100 rows but I'm trying to upload 7 million rows.
I have not seen the latest TSEARCH2 code release so
I don't have a great deal of understanding of the inner
workings.
Is there specific code that I can hack which will remove
a fix limitation such as the number of tokens before the
indexer quits or is the index type insufficient for the scale
of data.
Thanks,
Ted


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SSL cleanups/hostname verification
Next
From: "BRUSSER Michael"
Date:
Subject: corrupted pg_proc?