Home > database >  Postgresql fuzzy query in full, if the input is very slow in Chinese
Postgresql fuzzy query in full, if the input is very slow in Chinese

Time:10-01

Hello my database configuration is
The CREATE DATABASE postgres
WITH the OWNER=postgres
='UTF8 ENCODING'
In TABLESPACE=pg_default
LC_COLLATE="Chinese (Simplified) _People" 's Republic of China. 936'
LC_CTYPE="Chinese (Simplified) _People" 's Republic of China. 936'
The CONNECTION LIMIT=1;
If the full-text retrieval is in English, soon, Chinese is very slow

CodePudding user response:

Use pg_trgm index less than three characters don't go,
  • Related