|Full-Text Search in PostgreSQL: A Gentle Introduction|
|Prev||Fast Backward||Chapter 1. FTS Introduction||Fast Forward||Next|
Full text search engine in PostgreSQL is fully integrated into the database core. Its main features are:
It is mature, more than 5 years of development
Supports multiple configurations, which could be managed using a set of SQL commands.
Flexible and rich linguistic support using pluggable user-defined dictionaries with stop words supports. Several predefined templates, including ispell, snowball, Thesaurus and synonym dictionaries, are supplied.
Full multibyte support, UTF-8 as well
Sophisticated ranking functions with support of proximity and structure information allow ordering of search results according their similarity to the query.
Index support with concurrency and recovery support
Rich query language with query rewriting support