| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Greg Navis <contact(at)gregnavis(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [pg_trgm] Making similarity(?, ?) < ? use an index |
| Date: | 2016-06-03 19:27:03 |
| Message-ID: | CAMkU=1zJP351krhrc_PHE9f4L4gsm=iAqvXUoE-e2aT-FX8n7A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jun 3, 2016 at 12:13 PM, Greg Navis <contact(at)gregnavis(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-06-03 19:29:18 | Re: Londiste3 - Ubuntu 16.04 - Postgresql 9.3 |
| Previous Message | David G. Johnston | 2016-06-03 19:22:08 | Re: [pg_trgm] Making similarity(?, ?) < ? use an index |