On Tue, Dec 18, 2012 at 11:45 AM, Erik Rijkers
<er@xs4all.nl> wrote:
On Tue, December 18, 2012 08:04, Alexander Korotkov wrote:
I ran the same test again: HEAD versus trgm_regex v6, 7 and 9. In v9 there is some gain but also
some regression.
It remains a difficult problem...
If I get some time in the holidays I'll try to diversify the test program; it is now too simple.
Note, that regexes which contains {,n} are likely not what do you expect.
test=# select 'xq' ~ 'x[aeiou]{,2}q';
?column?
----------
f
(1 row)
test=# select 'xa{,2}q' ~ 'x[aeiou]{,2}q';
?column?
----------
t
(1 row)
You should use {0,n} to express from 0 to n occurences.
------
With best regards,
Alexander Korotkov.