Full Text Search in PG12
Oleg Bartunov - research scientist in the Lomonosov Moscow State University and contributor to PostgreSQL. He is also the co-founder and CEO of Postgres Professional company. Oleg is an active member of Russian PostgreSQL community, he advocated the adoption of PostgreSQL by astronomical community.
Oleg started using Postgres since 1995 and have been involved in PostgreSQL development since 1996 (he introduced a locale support). He has been involved in developing of extensibility infrastructure of PostgreSQL, GiST, GIN and SP-GiST templates for user-defined access methods , built-in full-text search facilities in PostgreSQL and a number of popular extensions: intarray, ltree, hstore, pg_trgm. His latest contribution are jsonb, RUM access method and jsonpath.
His main interests are Informaton Retrieval, Databases Extensibility, Algorithms and Data Structures, Service-Oriented Architecture for Science and XLDB for Science. In spare time he like to play volleyball, running, and enjoy adventure trekking in Himalaya.
No video of the event yet, sorry!
Full-Text Search ( FTS ) is a search for the documents, which satisfy query and, optionally, return them in some order. 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.
- 40 min
- PGConf India, 2020
- Application Developer