PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Oleg Bartunov
Teodor Sigaev
Day Talks - Day 1 - 2016-05-19
Room DMS 1120
Start time 15:00
Duration 00:45
ID 926
Event type Lecture
Track Hacking
Language used for presentation English

FTS is dead? Long live FTS!

New features of Full-text search in PostgreSQL

Long time ago we introduced full-text search in PostgreSQL, but since then it's development was stopped. It's popular feature of postgres and it has to be enhanced and improved to match users experience and wishes. We will present several new improvements in FTS, which addresses some of them.

From time to time we get messages from users about full-text search we developed many years ago. People ask about new features they would like to have in future version of FTS. Most popular were an ability to search for phrases, better support of *spell dictionaries and easier use. There were also complains about performance of FTS, comparison with other external search engines and questions about "fuzzy" search with FTS. Several people asked about ranking functions and underlying algorithms. Postgres becomes better and better with every release, but FTS even if it got benefit from index improvements, was still the same as we developed about 10 years ago. In this talk we will present several new improvements and features, which hopefully make full-text search in PostgreSQL more attractive and efficient.