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.