Full text search
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: