News for hackers. Stuff that matters.
Re:Setting Up a Fast, Comprehensive Search Routine with Post... by 1996 on Sunday July 29, 2018 @03:23PM (#17639803)
A larger problem is the need to precompute.

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.

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.