More of a perspective from just trying to index crap on my own machine vs building a SaaS
Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
11–20 of 27 posts
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#12> The Dark Side of the Moon
> OK Computer
Those are my 3 personal records ever. I feel so average now...
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#13Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#14these days i find myself yearning to type "Beatles abbey rd" and find only "Beatles abbey rd"
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#15these days i find myself yearning to type "Beatles abbey rd" and find only "Beatles abbey rd"
I learned this the hard way on a book platform I'm working on. While semantic search is useful for discovery, we found that prioritizing exact matches is critical. It seems users get pretty frustrated if they type a specific title and get a list of conceptually similar results instead of the actual book. We ended up having to tune the ranking to heavily favor literal string matches over the vector distance to keep pe…
...God help you if Brad Pitt and or the Jonas Brothers ever played a role with exactly that name-match. The web and search (and the culture?) have become super biased toward video especially commercial offerings, and the sorting ranked by popularity means pages and pages of virtually identical content about that which you are not interested in.
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#16Earlier quoted context omitted.
I learned this the hard way on a book platform I'm working on. While semantic search is useful for discovery, we found that prioritizing exact matches is critical. It seems users get pretty frustrated if they type a specific title and get a list of conceptually similar results instead of the actual book. We ended up having to tune the ranking to heavily favor literal string matches over the vector distance to keep pe…
everything you are saying rings perfectly true to me but there's an additional problem I encounter. (i'm going to make up my example because i'm lazy to check but you'll get the idea) say you want to look up "Alexander the Great"... ...God help you if Brad Pitt and or the Jonas Brothers ever played a role with exactly that name-match. The web and search (and the culture?) have become super biased toward video especia…
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#17Earlier quoted context omitted.
everything you are saying rings perfectly true to me but there's an additional problem I encounter. (i'm going to make up my example because i'm lazy to check but you'll get the idea) say you want to look up "Alexander the Great"... ...God help you if Brad Pitt and or the Jonas Brothers ever played a role with exactly that name-match. The web and search (and the culture?) have become super biased toward video especia…
Related but I wish Wikipedia would provide a filter against movies, music, pop culture related topics. They take up a huge amount of the namespace for things for whatever reason and often directs me to unintended pages.
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#18For GIN for example, perfomance depends a lot on the size of the search input (the fewer characters, the more rows to compare) as well as the number of rows/size of the index.
It also mentions GiST (another type of index which isn't mentioned anywhere else in the article)..
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#19> Abbey Road > The Dark Side of the Moon > OK Computer Those are my 3 personal records ever. I feel so average now...
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#20these days i find myself yearning to type "Beatles abbey rd" and find only "Beatles abbey rd"
I learned this the hard way on a book platform I'm working on. While semantic search is useful for discovery, we found that prioritizing exact matches is critical. It seems users get pretty frustrated if they type a specific title and get a list of conceptually similar results instead of the actual book. We ended up having to tune the ranking to heavily favor literal string matches over the vector distance to keep pe…