Thread: TSEARCH2 Thesaurus limitations
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>