Tomas Vondra <tomas.von...@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