Re: TSearch2 and optimisation ...

Herve'

> (cost=0.00..4052.84 rows=1351 width=166) (actual time=109.766..5415.108
> rows=139 loops=1)
>                      Index Cond: (idxfti @@ '\'postgresql\''::tsquery)
>                      Filter: (idxfti @@ '\'postgresql\''::tsquery)

From this, it looks like your FTI index isn't fitting in your sort_mem.
What's sort_mem at now?  Can you increase it?

Overall, though, I'm not sure you can get this sub-1s without a faster
machine.   Although I'm doing FTI on about 25MB of FTI text on a
single-processor machine, and getting 40ms response times, so maybe we can
...

--
Josh Berkus
Aglio Database Solutions
San Francisco