Introduction
Recap
In the previous article, we saw how we could use fuzzy search in PostgreSQL. This article is more about using the power of full-text indexes to search through large text data. This is different from any other PostgreSQL indexes, which work either with alphanumeric or smaller textual content.
Dataset Preparation
To understand how full-text search works, we are going to utilize the same data set we saw in the PostgreSQL Fuzzy Search blog -