[PERFORM] How to speed up word count with tsearch2?

I've tested several keyword count from 2 millions record book description table that indexed with tseach2 indexing. The result is always slow for first query attempt. This my sample query: -- test one phrase -- SELECT count(*) from table1 WHEREsearchvector @@ to_tsquery('default' ,'david') limit

[PERFORM] How to speed up word count in tsearch2?

(It is the 2nd posting, maybe the 1st one didn't goes thru) I've tested several keyword count from 2 millions record book description table that indexed with tseach2 indexing. The result is always slow for first query attempt. This my sample query: -- test one phrase -- SELECT count(*) from

Re: [PERFORM] How to speed up word count in tsearch2?

You need to look at what else is using RAM on that machine. And maybe buy more. Ouch.. I had that feeling also. then how can I know how much memory needed for certain amount words? and why counting uncommon words are faster than common one? ---(end of