tesearch2 question

Hi All,<br /><br />I'm trying to udpate a table containing  <span style="font-family: monospace;"></span>13149741
records.And its taking forever to complete this process. <br /><br />The update query i'm trying to run is for full
textindexing similiar to <br /><br /><pre>UPDATE tblMessages SET idxFTI=to_tsvector(strMessage);</pre><br />Below are
someof the stats which might be helpful for analyzing this<br /><br />$top<br /><br />   PID USERNAME LWP PRI NICE 
SIZE  RES STATE    TIME    CPU COMMAND <br />  3091 postgres   1  43    0   46M   38M cpu/1  200:06  3.20% postgres<br
/> 5052 postgres   1  60    0  149M  134M sleep    0:17  3.12% postgres<br /><br /><<<here are the top 2
processes,out of which the first process i have been running almost for a day and a half and it is still running, <br
/><br/>This table which i'm trying to  update has 10 indexes<br /><br
/>=========================================================<br/> "a_article_pk" PRIMARY KEY, btree (id)<br />   
"a_article_uk_pmid"UNIQUE, btree (pmid) <br />    "a_article_idx_abstract" btree ("substring"(abstract::text, 0,
255))<br/>    "a_article_idx_date_cr_year" btree (date_cr_year)<br />    "a_article_idx_ml_journal_info_medline_ta"
btree(ml_journal_info_a_ta) <br />    "a_article_idx_owner" btree ("owner")<br />    "a_article_idx_pmid" btree
(pmid)<br/>    "a_article_idx_status" btree (status)<br />    "a_article_idx_title" btree (article_title) <br />   
"a_master_t_idx_year_published"btree (published_year)<br />========================================================<br
/>Butno indexes on the field i'm trying to update. The field i'm trying to add is a new field. <br />Can anyone help me
outto figure out why is it taking so much time to update the table.<br /><br />Also as u see in the above indexes, I
havesome indexes on some varchar column which i feel are totally useless unless u so a exact string match. <br />But
doesthat help in any sense for improving the speed of retreiving the string just normally without any search on it?<br
/><br/>Thanks,<br />Sumeet.<br />