I started messing about with #postgres FTS in #Diaspora.

First, create a search column:

alter table posts add column fts_text_en tsvector generated always as (to_tsvector ('english', text )) stored;


Then, create a GIN a index on the new column:

create index posts_fts_text_en_idx on posts using gin(fts_text_en);


Next, query the column:

select id from posts where fts_text_en @@ websearch_to_tsquery('english', 'Linux');


Fast, simple. Prolly should integrate it into the search bar.