All Questions
Tagged with pg-trgm fuzzy-search
2 questions
0
votes
1
answer
141
views
Error while running fuzzy search using pg_trgm extension
I have created pg_trgm extension in postgres. Application works fine for querying for several days. But after few days, gives an error ERROR: operator does not exist: character varying % text
Hint: No ...
1
vote
2
answers
243
views
Matching a small table (<1,000 rows) to a large table (>100m rows) using pg_trgm—most efficient method?
This is a problem that comes up often in my work with various different data sets, so please excuse me presenting it in general terms rather than using a specific example.
I often need to get records ...