Bruce Momjian <bruce@xxxxxxxxxx> writes: > On Fri, Mar 4, 2022 at 10:41:16AM -0500, Bayer, Samuel wrote: >> I apologize for not being able to be more specific. > I know it is hard to quantify. Is it possible that Postgres is treating > all the terms equally, while Solr is prioritizing terms that are earlier > in the document? A few basic questions: * which ranking function are you using? * with what options? * which PG version exactly? As far as I can see from a quick look at the docs, neither ts_rank() nor ts_rank_cd() consider "earlier in the document" to be an interesting consideration. They do have the ability to prefer terms that have been marked as having a higher weight, but you'd need to do some setup work to make that useful --- basically, you'd have to separate out the title or other metadata and apply setweight() to it while building the tsvectors. I wouldn't be surprised if Solr has some well-tuned default heuristics that mean that you don't have to work hard to get good results from it. The current state of our FTS features is more like "here's all the parts, but you have to build the behavior you want". ISTM that our FTS features have basically been on autopilot since they went in. I'd sort of hoped that we'd see more parsers, more ranking functions, etc, over time ... but nothing like that has happened. I'm not sure if that's just lack of interest, or if people find the code too difficult to work with. regards, tom lane
