SING gist(idxFTI);
        VACUUM FULL ANALYZE;
</pre>
<p>After you have converted all of your data and indexed the
column, you can select some rows to see what actually happened. I
will not display output here but you can play around yourselves and
see what happened.</p>
<p>The last thing to do is set up a trigger so every time a row in
this table is changed, the text index is automatically updated.
This is easily done using:</p>
<pre>
        CREATE TRIGGER tsvectorupdate BEFORE UPDATE OR INSERT ON tblMes