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;
如果全文检索的是英文,很快,中文就非常慢