HackerTrans
TopNewTrendsCommentsPastAskShowJobs

arunmu

no profile record

Submissions

BM25 Search in Postgres

tigerdata.com
5 points·by arunmu·9 miesięcy temu·4 comments

comments

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