By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,952 Members | 1,119 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,952 IT Pros & Developers. It's quick & easy.

Finally tsearch works ... somehow... remain a few questions

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/postgr...-V2-intro.html
http://www.sai.msu.su/~megera/oddmus...earch_V2_Notes

Greetings
Marcel

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org


Regards,
Oleg
__________________________________________________ ___________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

P: n/a
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


Nov 23 '05 #3

P: n/a
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: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.