PostgreSQL Responds to Fuzzy or Regular Expression-based Searches within Seconds

This article illustrates different optimization methods to accelerate performance under distinct fuzzy search scenarios including prefix, suffix or fully fuzzy search and regex search.

PostgreSQL Fuzzy Search Best Practices: Single-word, Double-word, and Multi-word Fuzzy Search Methods

This article describes PostgreSQL best practices to optimize full-text search, fuzzy search, regex matches, and custom fuzzy searches.

Performance Optimization of Fuzzy Queries for Chinese Characters Using PostgreSQL trgm

This article describes how trgm, a powerful plugin significantly improves text search performance for fuzzy prefix and suffix queries as well as regexp matching.