tsuuhou

reading this post and following the links there you get a nice tool for fulltext searches in mysq;  sphinx

try looking at the benchmark – it’s quite impressive.

ibm has an article on building php based searchengines with sphinx

here is a wiki article on how to convert mysql databases to postgres

the article also explains differences in the sql language used by the two databases.