Hi,
I'm having a performance problem on a request using Tsearch2: the
request strangely takes several minutes.
I've tried to follow Tsearch tuning recommendations, I've searched
through the archives, but I can't seem to find a solution to solve my
problem.
The ts_vector field was created using
2008/2/5, Ansgar -59cobalt- Wiechers wrote:
Your planner estimates are way off. Try increasing the statistics target
for the columns used in this query and re-analyze the tables after doing
so.
I first set STATISTICS to 1000 for column zoneindex_test and saw no
significant improvement (with a