Forum OpenACS Q&A: Response to Searching a PostgeSQL database

That's a cute approach because it lets you use an index on the search rather than a sequential scan.  However, the size of the table will get huge for really busy sites that want to index full content, and you'll run into the 2 GB table size limit fairly quickly, I fear.

So the technique may have limited applicability for a general solution.  For the right scenario, though, it could work really well.