2 ms·
Hmm, was it "troublesome" in terms of performance building the index or doing the search or was there some other issue?
by sanderjd 12y ago
Hmm, was it "troublesome" in terms of performance building the index or doing the search or was there some other issue?
- rom16384 12y agoPart of the problem was due to the Django package we used to interface with the Postgres search, it wasn't designed to handle large tables. I don't recall how long the index took to build (hours? a day?), but the queries themselves were slow due to their complexity and ranking using ts_rank.
- sanderjd 12y agoInteresting, thanks for the info. What did you switch to? Were the queries significantly faster?