for text search we use the "rum" extension from postgrespro. search terabytes of pdfs < 1sec. a talk here

    https://github.com/jmscott/talk/blob/master/pgday-austin-20161112.pdf