Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE idea (
  id bigserial PRIMARY KEY
, title text
, subtitle text
-- , more ...
, text_search tsvector GENERATED ALWAYS AS (
      setweight(to_tsvector('english', COALESCE(title     , '')), 'A')
   || setweight(to_tsvector('english', COALESCE(subtitle  , '')), 'B')
-- || more ...
   ) STORED
);

CREATE TABLE

-- covers INSERT
INSERT INTO idea(title, subtitle) VALUES ('foo', 'bar')
RETURNING *;

id
title
subtitle
text_search

1
foo
bar
'bar':2B 'foo':1A

INSERT 0 1

-- covers UPDATE
UPDATE idea SET title = 'foo NEW'
RETURNING *;

id
title
subtitle
text_search

1
foo NEW
bar
'bar':3B 'foo':1A 'new':2A

UPDATE 1

SELECT * FROM idea
WHERE text_search @@ to_tsquery('english', 'bar:B');

id
title
subtitle
text_search

1
foo NEW
bar
'bar':3B 'foo':1A 'new':2A

SELECT 1

CREATE INDEX idea_text_search_gin_idx ON idea USING GIN (text_search);
-- force index for tiny table if possible
SET enable_seqscan = OFF;

EXPLAIN
SELECT * FROM idea
WHERE text_search @@ to_tsquery('english', 'bar:B');

CREATE INDEX

SET

QUERY PLAN

Bitmap Heap Scan on idea  (cost=8.00..12.01 rows=1 width=104)

  Recheck Cond: (text_search @@ '''bar'':B'::tsquery)

  ->  Bitmap Index Scan on idea_text_search_gin_idx  (cost=0.00..8.00 rows=1 width=0)

        Index Cond: (text_search @@ '''bar'':B'::tsquery)

EXPLAIN