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

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 Full-Text-Search (FTS), this is different. The purpose of the full-text search is to look for words or groups of words, which can be found in 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 (= "preprocessed tokens of words"), 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 the 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; 
主站蜘蛛池模板: 克山县| 东阿县| 新野县| 玉树县| 乌恰县| 广平县| 吴忠市| 芦山县| 临安市| 海盐县| 临汾市| 沾益县| 万山特区| 临西县| 清流县| 江口县| 平凉市| 鄂伦春自治旗| 麻阳| 高雄市| 桑日县| 嘉鱼县| 犍为县| 八宿县| 黄山市| 灌阳县| 武邑县| 武宁县| 巧家县| 藁城市| 蒙阴县| 霍城县| 台安县| 连江县| 海丰县| 灵台县| 花莲县| 奉新县| 永登县| 南皮县| 昌图县|