trigram Questions
3
Solved
Given this table:
foos
integer id
string name
string type
And a query like this:
select * from foos where name ilike '%bar%'
I can make a pg_trgm index like this to make lookups faster:
CREATE IN...
Reductase asked 5/2, 2014 at 21:58
2
Solved
I have a table which have only 7 columns and one of that column stores long text data for every row. Average character length for that text column data is approximately 1500 characters. And this ta...
Gatefold asked 16/9, 2021 at 23:59
2
Is it possible to tell ElasticSearch to use "best match" of all grams instead of using grams as synonyms?
By default ElasticSearch uses grams as synonyms and returns poorly matching documents. It'...
Glede asked 9/12, 2017 at 13:17
2
Solved
I do use the pg_trgm module in PostgreSQL to calculate similarity between two strings using trigrams. Particularly I use:
similarity(text, text)
Which returns returns a number that indicates how...
Sacaton asked 15/1, 2016 at 16:9
1
Given :
and the following :
For :
q(runs | the, dog) = 0.5
Should this not be 1 as for
q(runs | the, dog) : xi=runs , xi-2=the , xi-1=dog
Probability is (wi has been swapped for xi): ...
1
The postgres trigram documentation states:
The pg_trgm module provides GiST and GIN index operator classes that allow you to create an index over a text column for the purpose of very fast simil...
Baobaobab asked 11/2, 2020 at 21:12
3
Solved
Just testing PostgreSQL 9.6.2 on my Mac and playing with Ngrams.
Assuming there is a GIN trigram index on winery field.
The limit for similarity (I know this is deprecated):
SELECT set_limit(0.5)...
Physiotherapy asked 1/4, 2017 at 12:40
4
I have a migration:
class AddGinIndexToContacts < ActiveRecord::Migration
def up
execute("CREATE INDEX contacts_search_idx ON contacts USING gin (first_name gin_trgm_ops, last_name gin_trgm_o...
Hardihood asked 17/3, 2015 at 12:9
2
Solved
I have to implement a search function which will be fault tolerant.
Currently, I have the following situation:
Models:
class Tag(models.Model):
name = models.CharField(max_length=255)
class Ill...
Engadine asked 3/2, 2018 at 23:34
1
Solved
"Returns a number that indicates how similar the first string to the most similar word of the second string. The function searches in the second string a most similar word not a most similar substr...
Mcgovern asked 27/10, 2017 at 1:54
0
We're using Postgres and its fulltext feature to search for documents (posts content) in our system, and it works really well.
For autocomplete we want to build index (dictionary?) with all words ...
Starofbethlehem asked 26/11, 2016 at 22:36
1
© 2022 - 2024 — McMap. All rights reserved.