This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2017

Flexible full-text search

Date: 2017-10-25
Time: 15:00–15:50
Room: Baltic I
Level: Intermediate

We present a new approach to configuring full-text search in PostgreSQL. It allows to simplify creating custom configurations for solving most typical practical tasks by combining thesauri, morphological dictionaries, word transformers, stemmers etc. The basic idea is to move the hidden logic of document processing from inside the dictionaries to a higher level, where it could be configurable by user. The new approach is implemented by a new patch introducing a modified syntax for ALTER TEXT SEARCH CONFIGURATION. Several use cases will be discussed, including multilingual search with a priori unknown query language and exact word search. Additionally, we will present a Google Query-like language implementation for PostgreSQL full-text search. The talk will start with a brief introduction to full-text search, to make it understandable for beginners.


The following slides have been made available for this session:


Aleksandr Parfenov
Arthur Zakirov