Regardless of caching, the queries are still taking 19~20 seconds to run
on the 3,000,000 rows. I've played with performance tuning and nothing
seems to make much of a difference. If I am reading that list from stat
correctly, then I am operating on 508 distinct words. Is this the
performance I should expect from tsearch2? Or is something still awry?
I'm inclined to think something else is wrong, after reading some
other people's tsearch performance stats. Thanks!
Kris