ИСТИНА

Full-Text Search (FTS) finds the documents, which satisfy the query and, optionally, returns them in some order. FTS in PostgreSQL is fully integrated into database, so it ÷÷transactional, extensible The 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 depends on application. Document can live on a hard drive or to be completely virtual as a result of complex query. I will explain the importance of built-in FTS, the basics of FTS (configurations, query language and indexes) and present several new feautures of PG12, which improve FTS.