diff options
| author |  Frédéric Guillot <fred@miniflux.net> | 2018-10-19 21:40:59 -0700 |
|---|---|---|
| committer | Frédéric Guillot <fred@miniflux.net> | 2018-10-19 21:40:59 -0700 |
| commit | a614f980634003dae14b3675125f704d37856d0b (patch) | |
| tree | 752cd758dccf660313b5e4e2369247b2e5091d9c /database/sql | |
| parent | 715575001a2b5a96fa0cfc4402d29c959f1f48a0 (diff) | |
Set arbitrary maximum size for tsvector column
- The max size for tsvector is 1 MiB
- We index only the first million of characters,
it should be enough for most feed entries.
Diffstat (limited to 'database/sql')
| -rw-r--r-- | database/sql/schema_version_20.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sql/schema_version_20.sql b/database/sql/schema_version_20.sql index 228e162..18461b8 100644 --- a/database/sql/schema_version_20.sql +++ b/database/sql/schema_version_20.sql @@ -1,3 +1,3 @@ alter table entries add column document_vectors tsvector; -update entries set document_vectors = to_tsvector(title || ' ' || coalesce(content, '')); +update entries set document_vectors = to_tsvector(substring(title || ' ' || coalesce(content, '') for 1000000)); create index document_vectors_idx on entries using gin(document_vectors);
\ No newline at end of file |