"The State of (Full) Text Search in PostgreSQL 12" by Jimmy Angelakos
Channel: Peter Cooper
Date: 05/02/2020

Note: Republished under the Creative Commons Attribution 2.0 Belgium Licence (more info on why below).

How to navigate the rich but confusing field of (Full) Text Search in PostgreSQL. A short introduction will explain the concepts involved, followed by a discussion of functions, operators, indexes and collation support in Postgres in relevance to searching for text. Examples of usage will be provided, along with some stats demonstrating the differences.

Uploaded to this channel as we wanted to link this talk in the https://postgresweekly.com/ newsletter and it's not on FOSDEM's channel yet. FOSDEM's videos are, however, available to distribute via the Creative Commons Attribution 2.0 Belgium Licence, and so we are doing so here. The original information is at https://fosdem.org/2020/schedule/event/postgresql_the_state_of_full_text_search_in_postgresql_12/ and the speaker is Jimmy Angelakos