PgConf.Russia 2017 talks

Full text search capabilities in PostgreSQL

Arthur Zakirov
Postgres Professional, Developer

Arthur is a C programmer and PostgreSQL contributor. Presently works on improvment of full-text search features of PostgreSQL.

Teodor Sigaev
Postgres Professional, CTO

Teodor is one of the Russian PostgreSQL Major Contributors. Takes part in PostgreSQL development since 2000. Author of full-text search, GiST (together with Oleg Bartnunov) and other core features and extensions.

Full text search in PostgreSQL is probably the most advanced one among relational DBMS. This tutorial will explain how to setup full text search configurations and dictionaries and how to build a ful text search system using an example of a simple popular science web site, with demonstration of various ranking functions. Also I will tell about new RUM index, which allows to accelerate execution of some kinds of full text queries and implements a new improved ranking function.