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

From Tom Lane
Subject Re: full-text search with GiST indexes seems to be getting slower since 9.1
Date
Msg-id 17387.1588475353@sss.pgh.pa.us
Whole thread Raw
In response to full-text search with GiST indexes seems to be getting slower since 9.1  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List 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 by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: pg_ls_tmpdir to show directories and shared filesets (andpg_ls_*)
Next
From: Noah Misch
Date:
Subject: Re: implicit declaration of datumIsEqual in parse_coerce.c