So I have a table with about 50 million entries in it, I have to do a
keyword search.
The keyword search is done on the title of the entry. For example a entry could be "This is a
title string which could be searched"
I have tried a few ways to search but I get horrible search times. So
I have been trying to get keyword searching quicker
and have now decided to make smaller tables.
I was working with tables of about 50 000 000 rows
but now will use about 1.5million rows, I am using a TSearch2 to find keywords
in the titles column of the rows. I have indexes using a gist i
Forgot to mention that were running post gres 7.4.2
using a dual optiron system and 4gig ram. The results are used by the PHP web
server.
Thanks again
- Original Message -
From:
borajetta
To: [EMAIL PROTECTED]
Sent: Tuesday, July 06, 2004 10:52
AM
Subject
select count(*) FROM items_2004_07_29 as items
WHERE true AND index @@ to_tsquery('default', '( audiovox)') ; count
--- 4(1 row)
aers=# reindex index
idx_title_2004_07_29;REINDEXaers=# select count(*) FROM items_2004_07_29
as items WHERE true AND index @@ to_tsquery('default', '(