pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: query with pg_trgm sometimes very slow
Date: Tue, 08 Sep 2015 23:21:21 +0200
Message-ID: <55EF5151.7070409@2ndquadrant.com> (raw)
In-Reply-To: <CAHyXU0w2iUAA-_dreEK+5PE_0zdNFRHivtn_OHQf20fGkVxYDw@mail.gmail.com>
References: <55E7010F.8010700@vboehm.de>
	<CAMkU=1xN4M6UVFp39nceYEQE0JULFO42QiPcwkgtAFsey+5RLQ@mail.gmail.com>
	<CAGTBQpbfEhDz4vGabiZosn1j=iuEfAVOgwQfqf3iyeoE7hQ4zw@mail.gmail.com>
	<CAHyXU0w2iUAA-_dreEK+5PE_0zdNFRHivtn_OHQf20fGkVxYDw@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>



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=97f3014647a5bd570032abd2b809d32330...
>
> (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



view thread (6+ messages)  latest in thread

Message-ID: <55EF5151.7070409@2ndquadrant.com>
Permalink:  ../55EF5151.7070409@2ndquadrant.com/
Also on:    postgresql.org/message-id/55EF5151.7070409@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com
  Subject: Re: query with pg_trgm sometimes very slow
  In-Reply-To: <55EF5151.7070409@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox