TSEARCH2 Thesaurus limitations - Mailing list pgsql-hackers

From Theodore Wong
Subject TSEARCH2 Thesaurus limitations
Date
Msg-id BAY139-W5358935F9483D2D8BE25F8B22E0@phx.gbl
Whole thread Raw
List pgsql-hackers
Hi,<br />  <br /><font size="2"> I'm new to Postgres and would appreciate some help<br /> in understanding what the
limitationsof TSEARCH2 and<br /> the Thesauri operation.<br />  <br /> I'm trying to use the thesaurus as a
geo-tagger/coder.<br/> The first part of the problem is to create placename<br /> list with additional information such
asstate, county<br /> and country names.  But, the returned values are off.<br />  <br /> There's less of a problem
whenthe thesaurus is small<br /> under 100 rows but I'm trying to upload 7 million rows.<br />  <br /> I have not seen
thelatest TSEARCH2 code release so<br /> I don't have a great deal of understanding of the inner<br /> workings.<br />
 <br/> Is there specific code that I can hack which will remove<br /> a fix limitation such as the number of tokens
beforethe<br /> indexer quits or is the index type insufficient for the scale<br /> of data.<br />  <br /> Thanks,<br
/> <br /> Ted<br /></font><br /><hr />Want to read Hotmail messages in Outlook? The Wordsmiths show you how. <a
href="http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns!20EE04FBC541789!167.entry?ocid=TXT_TAGLM_WL_hotmail_092008"
target="_new">LearnNow</a> 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Hot Standby utility and administrator functions
Next
From: Tom Lane
Date:
Subject: Re: automatic parser generation for ecpg