Forum OpenACS Q&A: Response to How do I build search capabilities into a new application?

For Postgres, I would vote for integration with the openfts search facility.  I haven't personally enabled a package to be search-capable, but it looks pretty easy.

I would look at the notes package for an example of how to make forums available to search.  It is a simple package meant to demonstrate openfts search.

Basically, all that is needed is to create the appropriate FtsContentProvider service contracts and make two tcl procs: forums__datasource and forums__url.