All Questions
Tagged with pg-trgm similarity
3 questions
0
votes
0
answers
48
views
How could I optimize this SQL request to find similarity in name ? (pg_trgm.similarity)
I have created a query which takes about 15 min to complete with 20.000+ records
What I'm trying to do is pairing clients with similarity in their full name
My current query :
SELECT a.full_name, ...
- 333
0
votes
1
answer
173
views
How do I fetch similar posts from database where text length can be more than 2000 characters
As far as I'm aware, there is no simple, quick solution. I am trying to do a full-text keyword or semantic search, which is a very advanced topic. There are dedicated search servers created ...
- 43
1
vote
0
answers
114
views
pg_trgm, similarity and finding duplicate questions by their answers
I have a table named Questions. It has the content field (which contains a question) and an answer field. The whole table has around 22k rows and I'm trying to figure out how to search for duplicate ...
- 1,769