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 3 1282
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
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: 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: KefX |
last post by:
This may have been discussed before, but I'm kind of confused as to why Python
doesn't support having both an except ~and~ a finally clause, like this:
try:
raise RuntimeException
except:...
|
by: Joerg Erdmenger |
last post by:
Hi there,
I have an issue with tsearch. I'm using tsearch as a search mechanism on a
website making various queries created from the words that a user has put in.
So I query for all the words...
|
by: Joerg Erdmenger |
last post by:
Hi there,
me again. How do I find the stopwords that tsearch uses in its standard
configuration? I've looked at contrib/tsearch/dict/porter_english.dct and get
a feeling it's somewhere in there...
|
by: Nigel J. Andrews |
last post by:
This will be a little vague, it was last night and I can't now do the test in
that db (see below) so can't give the exact wording.
I seem to remember a report a little while ago about tsearch v2...
|
by: sector119 |
last post by:
Hi
Is there some one who was able to create ukrainian or russian-urainian
stemmer dict for tsearch v2?
--
WBR, sector119
---------------------------(end of...
|
by: Chris |
last post by:
Hi,
I am using the try catch finally block in many places in my code.
When a create an sqldatareader dr and try to close it in my
finally block I get the error: use of unsigned local variable....
|
by: Bas Scheffers |
last post by:
Hi,
Is there a way to use tsearch so that it returns documents that have less
than all the required keywords? The idea is that if a document only has 3
out of 4 terms, it is still returned, but...
|
by: Rajesh Kumar Mallah |
last post by:
Hi,
I think when search terms have "."s in them they become case sensitive
in tsearch searches. How can we make them insensitive?
Regds
Mallah.
|
by: linbl352 |
last post by:
Does anybody can tell me the following answers?
In the description of tsearch function, what is purpose of the callback function( compar) as follows:
void *tsearch(const void *key, void **rootp,
...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |