Re: query with pg_trgm sometimes very slow

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: query with pg_trgm sometimes very slow
Дата
Msg-id CAHyXU0x7UO49pr6pLk8W30DF+u8xe-EG7o8hHY8YJeHD8WhC2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query with pg_trgm sometimes very slow  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-performance
On Tue, Sep 8, 2015 at 4:21 PM, Tomas Vondra
<tomas.vondra@2ndquadrant.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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: query with pg_trgm sometimes very slow
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_stat_all_indexes understand