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 | |
| 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')
| -rw-r--r-- | database/sql.go | 4 | ||||
| -rw-r--r-- | database/sql/schema_version_20.sql | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/database/sql.go b/database/sql.go index be033fb..817feba 100644 --- a/database/sql.go +++ b/database/sql.go @@ -142,7 +142,7 @@ alter table users add column extra hstore; create index users_extra_idx on users using gin(extra); `, "schema_version_20": `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);`, "schema_version_21": `alter table feeds add column user_agent text default '';`, "schema_version_3": `create table tokens ( @@ -192,7 +192,7 @@ var SqlMapChecksums = map[string]string{ "schema_version_18": "c0ec24847612c7f2dc326cf735baffba79391a56aedd73292371a39f38724a71", "schema_version_19": "a83f77b41cc213d282805a5b518f15abbf96331599119f0ef4aca4be037add7b", "schema_version_2": "e8e9ff32478df04fcddad10a34cba2e8bb1e67e7977b5bd6cdc4c31ec94282b4", - "schema_version_20": "6c4e9b2c5bccdc3243c239c390fb1caa5e15624e669b2c07e14c126f6d2e2cd6", + "schema_version_20": "5d414c0cfc0da2863c641079afa58b7ff42dccb0f0e01c822ad435c3e3aa9201", "schema_version_21": "77da01ee38918ff4fe33985fbb20ed3276a717a7584c2ca9ebcf4d4ab6cb6910", "schema_version_3": "a54745dbc1c51c000f74d4e5068f1e2f43e83309f023415b1749a47d5c1e0f12", "schema_version_4": "216ea3a7d3e1704e40c797b5dc47456517c27dbb6ca98bf88812f4f63d74b5d9", 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 |