954
社区成员
发帖
与我相关
我的任务
分享postgresql全文模糊查询，如果输入的是中文非常慢
你好我的数据库配置是这样的
CREATE DATABASE postgres
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'Chinese (Simplified)_People''s Republic of China.936'
LC_CTYPE = 'Chinese (Simplified)_People''s Republic of China.936'
CONNECTION LIMIT = -1;
如果全文检索的是英文，很快，中文就非常慢
CREATE DATABASE postgres
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'Chinese (Simplified)_People''s Republic of China.936'
LC_CTYPE = 'Chinese (Simplified)_People''s Republic of China.936'
CONNECTION LIMIT = -1;
如果全文检索的是英文，很快，中文就非常慢
...全文
请发表友善的回复…
发表回复
月图灵 2017-12-22
- 打赏
- 举报
用pg_trgm少于三个字符不走索引。
