Message-ID: <55EF5151.7070409@2ndquadrant.com>
Date: Tue, 08 Sep 2015 23:21:21 +0200
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: query with pg_trgm sometimes very slow
References: <55E7010F.8010700@vboehm.de>
	<CAMkU=1xN4M6UVFp39nceYEQE0JULFO42QiPcwkgtAFsey+5RLQ@mail.gmail.com>
	<CAGTBQpbfEhDz4vGabiZosn1j=iuEfAVOgwQfqf3iyeoE7hQ4zw@mail.gmail.com>
 <CAHyXU0w2iUAA-_dreEK+5PE_0zdNFRHivtn_OHQf20fGkVxYDw@mail.gmail.com>
In-Reply-To: 
 <CAHyXU0w2iUAA-_dreEK+5PE_0zdNFRHivtn_OHQf20fGkVxYDw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


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).


-- 
Tomas Vondra                   http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance