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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
