This series describes PostgreSQL best practices to optimize full-text search, fuzzy search, regex matches, and custom fuzzy searches.
This article describes how PostgreSQL helps to perform fuzzy prefix or suffix query and regexp query by using database indexes, including GIN, GiST, RUM, and other customized indexes.
This article describes how to perform fuzzy searches for all the fields in a table using pg_trgm. It illustrates the implementation of a full-table and full-field fuzzy search with an example.
This article describes how trgm, a powerful plugin significantly improves text search performance for fuzzy prefix and suffix queries as well as regexp matching.
This article describes PostgreSQL best practices to optimize full-text search, fuzzy search, regex matches, and custom fuzzy searches.
This article lays down the performance differences between PostgreSQL fuzzy searches and regex matches, and further suggests ways to ways for SQL Optimization.
This article illustrates different optimization methods to accelerate performance under distinct fuzzy search scenarios including prefix, suffix or fully fuzzy search and regex search.
This post describes how to perform fuzzy queries or full-text searches on data before it is encrypted and ensure that your database supports encrypted storage.
7 2689 1
11 2849 0
12 1643 0
12 4218 1
9 4350 0
8 3384 0
11 2864 0
5 3358 0
6 3322 0
