Re: [ADMIN] VACUUM FULL

2002-05-11 Thread Rajesh Kumar Mallah.
Hi Brian, Yes contrib/tsearch does not provide relevence ranking at the moment, But OpenFTS-perl/tcl (openfts.sf.net) (from which tsearch is derieved) do provide relevence ranking and those are also very fast. and they work in similar fashion as you have metioned in your reply, also Open

Re: [ADMIN] VACUUM FULL

2002-05-11 Thread Brian McCane
Okay, now I am a little scared. Before I started rebuilding indexes, I decided to do the VACUUM FULL thing on all of my tables. On my two most referenced tables I am getting: ERROR: No one parent tuple was found What does this mean? Can I fix it without a full dump/restore? Where did it co

Re: [ADMIN] VACUUM FULL

2002-05-11 Thread Brian McCane
On Sat, 11 May 2002, Tom Lane wrote: > > Brian McCane <[EMAIL PROTECTED]> writes: > > It appeared while the VACUUM FULL was occurring, that the index files were > > sort of rewritten in place. > > No, it just has to make new index entries for the rows it moves. It > seems highly unlikely to me

Re: [ADMIN] VACUUM FULL

2002-05-11 Thread Brian McCane
I have tried contrib/tsearch, but I do fairly complex score computation based on word placement (headers,body,graphics,metatags, etc). And also do additional computations on the scores when the user does a search. It is very quick to use something like tsearch to figure out which pages match my