On Mar 1, 2006, at 6:54 , flood wrote:
Unfortunately I can not seem to get my query to use PG's full text indexing, it keeps doing a seq scan:
EXPLAIN SELECT t1.id, t2.id FROM test1 t1, test2 t2 WHERE lower( t1.keyword ) ~ ( lower ( '^' || t2.article ));
It doesn't appear that you're using tsearch2. PostgreSQL does not include full text search in the basic installation. Have you installed tsearch2?
Michael Glaesemann grzm myrealbox com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
