Forums specific search for postgresql is implemented with just a few database queries. The site-wide search uses the Search package with OpenFTS full text indexing. It is quite effective. Every page has a search form in the header that uses this site-wide search.
