 searching of text based fields, very useful for websites
(and other applications) that require a results set based on key
words. PostgreSQL ships with a contributed module called tsearch2,
which implements a special type of index that can also be used for
full text indexing. Further more, unlike MS' offering which
requires regular incremental rebuilds of the text indexes
themselves, tsearch2 indexes are always up-to-date and keeping them
so induces very little overhead.</p>
<p>Before we get into the detail