Full text search

PGDay : How does Full Text Search works?

During last PGDay I gave a presentation how Full Text Search works in PostgreSQL. This feature is unfortunately not well known. I see several reasons for this: Complexity: The FTS uses unknown notions from DBA: stemming, vector representation of a document … The tendency to use a dedicated tool for full-text search: ElasticSearch, SOLR … PostgreSQL’s advanced features are not known. However, there are several advantages to use the PostgreSQL FTS: