The anatomy of FTS engine in PostgreSQL.
Oleg Bartunov is a research scientist in the Lomonosov Moscow State University, major contributor to PostgreSQL. He is also the co-founder and CEO of Postgres Professional company.
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 and RUM access method. Currently, he is working on implementation of SQL/JSON standard for PostgreSQL.
Oleg graduated from the department of Astronomy at Lomonosov Moscow State University. During his professional work at Sternberg Astronomical Institute he realized he needed a free and powerful open-source database like PostgreSQL (Postgres95 that time). Since then he extensively used PostgreSQL in his scientific work and many other projects. Oleg is an active member of Russian PostgreSQL community, he advocated the adoption of PostgreSQL by astronomical community.
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!
PostgreSQL Full Text Search is a flexible way to search documents stored in PostgreSQL database matching a given query. Latest versions of Postgres introduced several features, which makes FTS of jsonb documents more easy. I will talk about the use cases, the architecture of FTS and how to use its flexibility and configure for best performance. The talk will includes a data types, operators with indexes (GiST, GIN, Rum), phrase search, jsonb, jsonpath, dictionaries, discussion of some recent improvements and roadmap for future releases. Also, I will present several new improvements of FTS
- 50 min
- Postgres Conference 2020