Skip to content

Latest commit

 

History

History
20 lines (14 loc) · 703 Bytes

README.md

File metadata and controls

20 lines (14 loc) · 703 Bytes

postgres with chinese textsearch support just for my miniflux compatibility

add zhparser and pg_jieba

build

git pull
Docker build -t name:tag .

migrate from exist database

  1. In postgresql.conf, set default_text_search_config to 'chinese'
  2. In psql, connect to database and run:
UPDATE entries SET document_vectors = setweight(to_tsvector(left(coalesce(title, ''), 500000)), 'A') || setweight(to_tsvector(left(coalesce(content, ''), 500000)), 'B');

(This comes from miniflux. But also split the link in content to words, looking for better way.)