PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Oleg Bartunov |
|
Teodor Sigaev |
| Schedule | |
|---|---|
| Day | Talks - first day - 2009-05-21 |
| Room | DMS 1150 |
| Start time | 10:00 |
| Duration | 01:00 |
| Info | |
| 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.