PGCon2016 - 20180510
PGCon 2016
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Oleg Bartunov |
|
Teodor Sigaev |
| Schedule | |
|---|---|
| Day | Talks - Day 1 - 2016-05-19 |
| Room | DMS 1120 |
| Start time | 15:00 |
| Duration | 00:45 |
| Info | |
| 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.