ИСТИНА

Full-Text Search ( FTS ) is a search for the documents, which satisfy query and, optionally, return them in some order. Most usual case is to find documents containing all query terms and return them in order of their similarity to the query. Notions of query and similarity are very flexible and depend on specific applications. I will explain why do you need a built-in FTS, while there are many off-database solutions like Solr, Sphinx or Elastic Search. Also, I will present a state of art FTS in PostgreSQL, including new features like phrase search, web query, RUM index and new ranking function, better flexible FTS configuration and discuss a development roadmap.