Re: query with pg_trgm sometimes very slow

On Tue, Sep 8, 2015 at 4:21 PM, Tomas Vondra
<tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
> On 09/08/2015 09:15 PM, Merlin Moncure wrote:
> ...
>>>
>>> I just had the exact same problem, and indeed gin fares much better.
>>
>>
>> Also, with 9.5 we will see much better worst case performance from gin
>> via Jeff's patch:
>>
>> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=97f3014647a5bd570032abd2b809d3233003f13f
>>
>> (I had to previously abandon pg_tgrm for a previous project and go
>> with solr; had this patch been in place that would not have happened)
>
> Except that pg_tgrm-1.2 is not included in 9.5, because it was committed in
> July (i.e. long after 9.5 was branched).

oops! thinko. it shouldn't be too difficult to back patch though if
you're so inclined?

merlin