Pg_bm25 extension support
We're using Neon for all our data needs and want to implement a hybrid search (syntactic and semantic). For the semantic search,
pg_vector is enough but for the syntactic search ts_rank_cd or the trigram index is not as powerful as BM25.
We feel that BM25 is going to help Neon reach Elasticsearch level and will be a massive improvement for anyone implementing text search.
Can you please help with this? If it is possible and if so, when can we expect it?5 Replies
conscious-sapphire•15mo ago
https://github.com/neondatabase/cloud/issues/11177
For now we cannot support it as it does not integrate into our custom storage engine
wise-whiteOP•15mo ago
The URL you shared is not accessible.
conscious-sapphire•15mo ago
Oh, oops. I thought it was the other repo :D. We have it tracked but I don't think it's on any roadmap
wise-whiteOP•15mo ago
Any suggestions for a syntactic text search using Neon in the meanwhile?
continuing-cyan•15mo ago
pg_trgm?