HackerTrans
TopNewTrendsCommentsPastAskShowJobs

arunmu

no profile record

Submissions

BM25 Search in Postgres

tigerdata.com
5 points·by arunmu·vor 9 Monaten·4 comments

comments

arunmu
·vor 24 Tagen·discuss
Were you using it for simple grep search or actually required advanced searching for eg: BM25. Clickhouse will only help you with grep like search from what I understand.
arunmu
·vor 8 Monaten·discuss
There is pgvectorscale from timescale which uses disk ann based data structure and has support for pre and post filtering.
arunmu
·vor 9 Monaten·discuss
Thanks. We are already using timescale postgres image for pgvectorscale with some customizations on tsvector and GIN indexes. Would be nice to have bm25 as well. Any specific reason why this was not made open source from the get go or is it the usual phased approach by Timescale (now Tigerdata)? If not, it is a worrying signal as the same could happen with pgvectorscale development as well.

Anyways really appreciate the free offerings by timescale. Really makes things easy.
arunmu
·vor 9 Monaten·discuss
I would very much like it if it was opensourced like pgvectorscale and timescale extension itself