Postgres Pro
Downloads
Home   >   mailing lists

Re: [pg_trgm] Making similarity(?, ?) < ? use an index - Mailing list pgsql-general

From Greg Navis
Subject Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Date
Msg-id CAA6WWt8gHi0v5UxSBS=RhJKx2Nd7Tj8OuS0OKN01KR_JYbeHmw@mail.gmail.com
Whole thread Raw
In response to Re: [pg_trgm] Making similarity(?, ?) < ? use an index  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [pg_trgm] Making similarity(?, ?) < ? use an index  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view
Thanks for answers and sorry for not searching hard enough.

I'm curious ... would it be difficult to modify PostgreSQL so that it'd use the index for `similarity(lhs, rhs) >= show_limit()` too? Or even add `is_similar(lhs, rhs, threshold)` that'd allow to change the threshold on a per-query basis. I might be able to block some time to contribute.

Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.

pgsql-general by date:

Previous
From: Leonardo M. Ramé
Date:
Subject: Londiste3 - Ubuntu 16.04 - Postgresql 9.3
Next
From: Leonardo M. Ramé
Date:
Subject: Re: Londiste3 - Ubuntu 16.04 - Postgresql 9.3