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
Wednesday, July 26, 2006
Load Balance
It's becoming harder and harder to handle databg's on one server only.
I started to look for some load balance scheme.
Seems that DNS load balance is the easiest way to achieve a load balance and most popular one.
I am going to try it and then will share my experience.
I started to look for some load balance scheme.
Seems that DNS load balance is the easiest way to achieve a load balance and most popular one.
I am going to try it and then will share my experience.
Subscribe to:
Posts (Atom)