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.
Friday, July 28, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment