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>