Stack Overflow
Stack Overflow

Questions tagged [pg-trgm]

Postgres trigram match module

Postgres trigram match module https://www.postgresql.org/docs/current/static/pgtrgm.html

58 questions
0
votes
0 answers

Trigram search with pg_search in Rails not returning anything

I've looked through everything and can't seem to find an answer or whats wrong. Ive run my migrations .I have bundle installed with the gems "pg_trgm" and "pg_search". I can see " enable_extension "pg_trgm" " has been added to my schema. Model and…
Anna Luz Fisher
  • 1
  • 1
0
votes
1 answer

Real number comparison for trigram similarity

I am implementing trigram similarity for word matching in column comum1. similarity() returns real. I have converted 0.01 to real and rounded to 2 decimal digits. Though there are rank values greater than 0.01, I get no results on screen. If I…
Mehul
  • 19
  • 4
0
votes
1 answer

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 operator matches the given name and argument…
Prerna
  • 3
  • 2
0
votes
1 answer

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 specifically for that reason, but still is there a way that…
Arnob
  • 43
  • 5
0
votes
0 answers

PostgreSQL search using like does not return right value

I am using pg_trgm in my name column as : create index if not exists idx_gin_iperson_name on iperson using gin (name gin_trgm_ops) in iperson table, I have a column with name Jose Goruir and in query: SELECT * FROM iperson p where ((name ilike…
Alireza Rahmani Khalili
  • 2,727
  • 2
  • 32
  • 33
0
votes
1 answer

Postgres function raising error when calling from Python script but running fine in PgAdmin

I have a postgres function called 'medrealize()' inside which i am creating temp table and creating index for temp tables using below lines CREATE INDEX SQLOPS_RefICD_ICD10_idx ON t$SQLOPS_RefICD_ICD10 USING gist (code gist_trgm_ops ); CREATE INDEX…
User123
  • 793
  • 4
  • 10
  • 28
0
votes
1 answer

Set GUC parameter or use PGOPTIONS environment variable with PgBouncer

Can I make PgBouncer preserve the PGOPTIONS environment variable in transaction pooling to configure GUC parameters? Or is there another way to configure these parameters in PgBouncer so that it applies to all connections? I specifically need to set…
Frederik Baetens
  • 781
  • 1
  • 9
  • 20
0
votes
1 answer

Install pg_trgm on postgres 9.4.24

I'm trying to use the similarity function on a Greemplum system using postgres 9.4.24 version. The Greenplum System is running on a CentOS 7 cluster (CentOS Linux release 7.9.2009 (Core)) I've managed to install the postgresql-contrib package by…
Matias
  • 539
  • 5
  • 28
0
votes
1 answer

Fuzzy date search/Optimizing LIKE with date type

Well, I will be pretty straightforward - I encountered with huge performance drop when implementing birthday search in my app - I'm using LIKE and this is not left-anchored expression (as date column format looks like YYYY-MM-DD), so i had to do…
Pavel Nasevich
  • 400
  • 1
  • 3
  • 13
0
votes
1 answer

How do I use pg_trgm to be more permissible

I used pg_trgrm to check string matches and I am pretty happy with the results. But it is not pefrectly the way I want it. I want that searches like "poduto" finds "produtos" (the r was missing). And Also that "sofáa" finds "sofa". I am using…
Diego Alves
  • 2,462
  • 3
  • 32
  • 65
0
votes
1 answer

How to use pg_trgm functions in JOOQ

Is it possible to use pg_trgm functions as similarity in JOOQ?
Anton Feoktistov
  • 321
  • 1
  • 9
0
votes
1 answer

postgresql pg_trgm speed up by where conditions

I use pg_trgm extension to check similarity of a text column. I want to speed it up by using additional conditions, but without success. The speed is the same. Here is my example: create table test ( id serial, descr text, yesno…
Stepan Pavlov
  • 119
  • 2
  • 3
  • 7
-1
votes
1 answer

Can this postgresql query be further optimized?

we're building a translation editor and one of the main use cases is to find similar translations in the database. The main entities are: segment, translation_record and user. Segment can be either source or target segment (text) with…
Sebastjan Hribar
  • 396
  • 3
  • 13
1 2 3
4