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

From Jeff Janes
Subject Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Date
Msg-id CAMkU=1zJP351krhrc_PHE9f4L4gsm=iAqvXUoE-e2aT-FX8n7A@mail.gmail.com
Whole thread Raw
In response to Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Greg Navis <contact@gregnavis.com>)
Responses Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Re: [pg_trgm] Making similarity(?, ?) < ? use an index
List pgsql-general
On Fri, Jun 3, 2016 at 12:13 PM, Greg Navis <contact@gregnavis.com> wrote:
> 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?

Yes, that would be very difficult. The project has kind of painted
itself into a corner on that.

If it were easy, I doubt we would have added the % operator with the
ugly set_limit() wart in the first place (although I was not around at
the time that was done--maybe there were other considerations).

Cheers,

Jeff


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Next
From: Adrian Klaver
Date:
Subject: Re: Londiste3 - Ubuntu 16.04 - Postgresql 9.3