On Tue, Sep 8, 2015 at 4:21 PM, Tomas Vondra <tomas.vondra@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
