|From:||Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru>|
|To:||Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>|
|Cc:||Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>|
|Subject:||Re: Fuzzy substring searching with the pg_trgm extension|
|Views:||Raw Message | Whole Thread | Download mbox|
On 02.02.2016 15:45, Artur Zakirov wrote:
> On 01.02.2016 20:12, Artur Zakirov wrote:
>> I have changed the patch:
>> 1 - trgm2.data was corrected, duplicates were deleted.
>> 2 - I have added operators <<-> and <->> with GiST index supporting. A
>> regression test will pass only with the patch
>> 3 - the function substring_similarity() was renamed to
>> But there is not a function substring_similarity_pos() yet. It is not
> Sorry, in the previous patch was a typo. Here is the fixed patch.
I have attached a new version of the patch. It fixes error of operators
<->> and %>:
- operator <->> did not pass the regression test in CentOS 32 bit (gcc
- operator %> did not pass the regression test in FreeBSD 32 bit (gcc
It was because of variable optimization by gcc.
In this patch pg_trgm documentation was corrected. Now operators were
wrote as %> and <->> (not <% and <<->).
There is a problem in adding the substring_similarity_pos() function. It
can bring additional overhead. Because we need to store characters
position including spaces in addition. Spaces between words are lost in
Does it actually need?
In conclusion, this patch introduces:
1 - functions:
2 - operators:
3 - GUC variables:
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
|Next Message||Fabien COELHO||2016-02-10 15:37:13||Re: extend pgbench expressions with functions|
|Previous Message||Robert Haas||2016-02-10 15:21:11||Re: [PATCH] Refactoring of LWLock tranches|