You just proved my point...if I have to install a standalone Java full-text engine running on Tomcat, I've already gone beyond what most forum owners can do on shared hosting.
Imagine searching through all posts on HN for the phrase "proved my point" anywhere in the post. There is no way other than iterating through all of the millions of posts.
For commonly-searched phrases such as "P vs NP", "scalability", or "rate my startup" you can create an index for faster searching, but it is impossible to anticipate every possible search, and in particular, long tail searches which can be the most useful will be the least likely to be indexed.