Re:Setting Up a Fast, Comprehensive Search Routine with Post...
by manigandham on Sunday July 29, 2018 @03:33PM
(#17639846)
A trigger to do the update for the tsvector field works just fine, and is the normal implementation.
Regular views are just as slow (or fast) as the normal code.
It seems something inbetween would be needed- not just a trigger, but a regular update as data is appended, maybe in chunks?
I do not know psql much. It may already exist.