Re: full-text search with GiST indexes seems to be getting slower since 9.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: full-text search with GiST indexes seems to be getting slower since 9.1
Дата
Msg-id 17387.1588475353@sss.pgh.pa.us
обсуждение исходный текст
Ответ на full-text search with GiST indexes seems to be getting slower since 9.1  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> over the past couple of weeks I've been running various benchmarks with
> the intent to demonstrate how the performance evolved since ~8.3. In
> most tests we're doing pretty good, but I've noticed that full-text
> search using GiST indexes is an annoying exception - it's getting slower
> and slower since ~9.1.

Hmmm... given that TS_execute is near the top, I wonder if this has
anything to do with the several times we've mostly-rewritten that
to make it less incorrect for phrase search cases.  But that came in
in 9.6 IIRC, and the fixes have only been back-patched that far.
Don't know what might've changed in 9.3.

            regards, tom lane



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: pg_ls_tmpdir to show directories and shared filesets (andpg_ls_*)
Следующее
От: Noah Misch
Дата:
Сообщение: Re: implicit declaration of datumIsEqual in parse_coerce.c