Is there any documentation available on how to go about creating these indexes on my text fields?
I'm at a bit of a loss here, Google is failing me sadly
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
We made quite good experiences with tsearch2. The problem for you could be that the case sensititity gets lost.
Raph
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend