Обсуждение: Finally tsearch works ... somehow... remain a few questions
For now i am almost statisfied with my tsearch2 installation war over night somehow it seems to work, finally... 3 probably easy questions remain... 1.) Is it possible to index already filled tables? 2.)Can i have seperated indexes for different columns in a table 3.) Can i create an extra Table just for my indexes that is not included in my data table? Greetings Marcel
Marcel, On Thu, 19 Aug 2004, Marcel Boscher wrote: > For now i am almost statisfied with my tsearch2 installation war over night > somehow it seems to work, finally... what problems with installation ? Any additions,corrections to docs ? > > 3 probably easy questions remain... > 1.) Is it possible to index already filled tables? sure. It's written many times. Check to_tsvector() function > 2.)Can i have seperated indexes for different columns in a table why not, you may have separate indices or one index with different weights assigned to each column (up tp 4 columns) > 3.) Can i create an extra Table just for my indexes that is not included > in my data table? I don't understand this. Example, please. Seems, you need to reread documentation. http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes > > Greetings > Marcel > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Oleg Bartunov wrote: > Marcel, > > On Thu, 19 Aug 2004, Marcel Boscher wrote: > > >>For now i am almost statisfied with my tsearch2 installation war over night >>somehow it seems to work, finally... What does have tsearch2 that htdig doesn't have ( for index document I mean ) ? Regards Gaetano Mendola
On Thu, 19 Aug 2004, Gaetano Mendola wrote: > Oleg Bartunov wrote: > > > Marcel, > > > > On Thu, 19 Aug 2004, Marcel Boscher wrote: > > > > > >>For now i am almost statisfied with my tsearch2 installation war over night > >>somehow it seems to work, finally... > > What does have tsearch2 that htdig doesn't have ( for index document I mean ) ? > Most important - index consistency and native access to document metadata. > > > Regards > Gaetano Mendola > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83