Re: [SQL] tesearch2 question

On Wed, 7 Mar 2007, Sumeet wrote: Thanks Oleg, My String message are Abstracts of papers, I did a $ select avg(len) from (select length(abstract) as len from master_table limit 500) E; avg --- 1355.5907859078590786 (1 row) so length is approx 1400. that'is abou

Re: [SQL] tesearch2 question

Thanks Oleg, My String message are Abstracts of papers, I did a $ select avg(len) from (select length(abstract) as len from master_table limit 500) E; avg --- 1355.5907859078590786 (1 row) so length is approx 1400. I couldn't find any appropriate way to analyze t

Re: [SQL] tesearch2 question

On Wed, 7 Mar 2007, Sumeet wrote: Hi All, I'm trying to udpate a table containing 13149741 records. And its taking forever to complete this process. The update query i'm trying to run is for full text indexing similiar to UPDATE tblMessages SET idxFTI=to_tsvector(strMessage); How big are

[SQL] tesearch2 question

Hi All, I'm trying to udpate a table containing 13149741 records. And its taking forever to complete this process. The update query i'm trying to run is for full text indexing similiar to UPDATE tblMessages SET idxFTI=to_tsvector(strMessage); Below are some of the stats which might be helpfu