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.
The second solution is better, but please read documentation [1] before replicating it. Also to_tsvector takes an optional regconfig parameter [2] and here is what I get right now
[1] https://www.postgresql.org/docs/current/static/textsearch-co...[2] https://www.postgresql.org/docs/current/static/textsearch-in...