Full Text Search in PG12
Schedule

Presented by:

9de563369b8e83cdadf196183ab6f870

Oleg Bartunov

from Moscow University, Postgres Professional

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.

Download slides

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.

Date:
2020 February 27 - 11:00
Duration:
40 min
Room:
Grand Victoria 2
Conference:
PGConf India, 2020
Language:
Track:
Application Developer
Difficulty:
Medium

Happening at the same time:

  1. Avoiding, Detecting, and Recovering From Data Corruption
    2. Start Time:
    2020 February 27 11:00

    Room:
    Grand Victoria 1

  2. Taming 100+ PostgreSQL instances on the Cloud
    3. Start Time:
    2020 February 27 11:00

    Room:
    Robusta + Arabica