multi-column index for string match + string similarity with pg_trgm? Optimizing Postgre SQL Queries Combining String Matching and String Similarity with pg trgm When working with large datasets in Postgre SQL optimizing queries f 2 min read 06-09-2024 21
Why is postgres trigram word_similarity function not using a gin index? Why Postgres Trigram word similarity Function Doesnt Always Use GIN Indexes The Postgre SQL pg trgm extension offers powerful functionality for performing fast 2 min read 05-09-2024 12
How to obtain and save trigrams from text mining program TM - in text or csv format Extracting and Saving Trigrams from Text with TM A Step by Step Guide This article explores how to extract trigrams sequences of three words from text using the 3 min read 28-08-2024 24