PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Oleg Bartunov
Teodor Sigaev
Day Talks - first day - 2009-05-21
Room DMS 1150
Start time 10:00
Duration 01:00
ID 119
Event type Lecture
Track Advanced Features
Language used for presentation English

Some recent advances in full-text search

We will present some recent improvements in full-text search, we developed during 8.4 development stage and after.

The main goal of our talk is to explain some innovations in full-text search and present several advanced techniques from real-life applications - some of them are a new operator for full-text query, phrase search, prefix search and new framework for lexeme processing for better test search management. Also, we'll explain how to write new dictionaries and present several useful dictionaries. We'll show how to solve some typical problems, for example, how to correctly work with diacritical signs (accents), which are common to european languages, how to scale full-text search. New B-tree emulation feature of GIN allows effective usage of multicolumn GIN indexes introduced in 8.4 and faster full-text search.