Comment Comment by atombender Why not just have a GIN index on the expression to_tsvector(body, 'english') or whatever? Then you don't need to maintain a separate column. parent atombender 8 years ago