Skip to content

Add full text search

Lukas Möller requested to merge full-text-search into staging

Just a small experiment: Does a full text search on answers ("text"), comments ("text"), exams ("text" + "remark") and exam pages ("text"). Pdf text is extracted using pdftotext (Uses the poppler pdf parser). To speed up the search the SearchVector is stored and updated when one of the attributes is updated using a TRIGGER. I also added a GIN index for the search_vector columns. A trigram ranking function is used on exam pages.

Searching on 15333 answers takes ~10 ms and ~80 ms with django + python overhead (without GIN and stored tsvector it takes ~1500 ms)

Screen_Shot_2020-08-23_at_23.53.40

Edited by Lukas Möller

Merge request reports