Friday, July 28, 2006

PostgreSQL Fulltext Search

After I decided that mysql's fulltext search is pretty slow I wanted to try PostgreSQL as DB for http://databg.svilen.com

In my current company we are successfully using PostgreSQL as a Database for our billing and hosting systems and it's perfect!

So there is a fulltext search extension for PostgreSQL called Tsearch2 (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/)
It wasn't so easy to install it. :) Although everyone says it's almost as easy as playing with your *** :)

Anyway. Finally Tsearch2 is installed.
Test shows that PG isn't much faster and it has no query cache ?!?

I'm going to revert to MySQL unfortunately.

No comments:

Post a Comment