blob: 18461b89d0ea76349793c10f70a381ed6a893e59 (
plain)
1
2
3
|
alter table entries add column document_vectors tsvector;
update entries set document_vectors = to_tsvector(substring(title || ' ' || coalesce(content, '') for 1000000));
create index document_vectors_idx on entries using gin(document_vectors);
|