| From: | Yudie Pg <yudiepg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | How to speed up word count with tsearch2? |
| Date: | 2005-03-31 18:52:48 |
| Message-ID: | e460d0c050331105242d0416@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 100
:: returns 16824 records match.
:: take 49618.341 ms (1st attempt)
:: take 504.229 ms (2nd attempt)
-- test two phrase --
SELECT count(*) from table1
WHERE searchvector @@ to_tsquery('default' ,'martha&stewart') limit 100
:: returns 155 records match.
:: take 686.669 ms (1st attempt)
:: take 40.282 ms (2nd attempt)
I use ordinary aggregate function count(*), Is there other way to count faster?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Madison Kelly | 2005-03-31 19:04:01 | Very long time to execute and Update, suggestions? |
| Previous Message | Richard_D_Levine | 2005-03-31 18:24:30 | Re: Reading recommendations |