Full text search capabilities in PostgreSQL
Postgres Professional, Developer
Arthur is a C programmer and PostgreSQL contributor. Presently works on improvment of full-text search features of PostgreSQL.
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.