HackerTrans
TopNewTrendsCommentsPastAskShowJobs

arunmu

no profile record

Submissions

BM25 Search in Postgres

tigerdata.com
5 points·by arunmu·9 個月前·4 comments

comments

arunmu
·24 天前·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
·8 個月前·discuss
There is pgvectorscale from timescale which uses disk ann based data structure and has support for pre and post filtering.
arunmu
·9 個月前·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
·9 個月前·discuss
I would very much like it if it was opensourced like pgvectorscale and timescale extension itself