官术网_书友最值得收藏!

  • Mastering PostgreSQL 9.6
  • Hans Jurgen Schonig
  • 294字
  • 2021-07-09 19:57:23

Understanding full-text search - FTS

If you are looking up names or for simple strings, you are usually querying the entire content of a field. In FTS, this is different. The purpose of full-text search is to look for words or groups of words, which can be found inside a text. Therefore, FTS is more of a contains operation as you are basically never looking for an exact string.

In PostgreSQL, FTS can be done using GIN indexes. The idea is to dissect a text, extract valuable lexemes, and index those elements rather than the underlying text. To make your search even more successful, those words are preprocessed.

Here is an example:

test=# SELECT to_tsvector('english', 'A car, I want a car. I would not even mind having many cars'); 
to_tsvector
---------------------------------------------------------------
'car':2,6,14 'even':10 'mani':13 'mind':11 'want':4 'would':8
(1 row)

The example shows a simple sentence. The to_tsvector function will take the string, apply English rules and perform a stemming process. Based on the configuration (english), PostgreSQL will parse the string, throw away stop words and stem individual words. For example, car and cars will be transformed to car. Note that this is not about finding the word stem. In the case of many, PostgreSQL will simply transform the string to mani by applying standard rules working nicely with the English language.

Note that the output of the to_tsvector function is highly language dependent. If you tell PostgreSQL to treat the string as Dutch, the result will be totally different:

test=# SELECT to_tsvector('dutch', 'A car, I want a car. I would not even mind having many cars'); 
to_tsvector
-----------------------------------------------------------------
'a':1,5 'car':2,6,14 'even':10 'having':12 'i':3,7 'many':13
'mind':11 'not':9 'would':8
(1 row)

To figure out which configurations are supported, consider running the following query:

SELECT cfgname FROM pg_ts_config;
主站蜘蛛池模板: 正镶白旗| 柏乡县| 南开区| 蕲春县| 岢岚县| 仪陇县| 昌邑市| 兰州市| 云南省| 连州市| 汨罗市| 吴忠市| 景洪市| 双鸭山市| 东乡族自治县| 卓资县| 台前县| 新源县| 邯郸市| 扎赉特旗| 潜山县| 仲巴县| 石家庄市| 富裕县| 定陶县| 江北区| 江阴市| 封开县| 达州市| 浦东新区| 江源县| 曲沃县| 德清县| 托克托县| 兴隆县| 拜泉县| 廊坊市| 芷江| 长寿区| 南丰县| 农安县|