#tsvector — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #tsvector, aggregated by home.social.
-
If you are building an application that requires search, I recommend using Elasticsearch early on. In addition to the usual full-text search, Elasticsearch allows you to perform a hybrid search: combine the results of text and vector search.
Of course, for small amounts of data, you can use PostgreSQL tsvector with the pgvector extension, but in the long term, Elasticsearch will provide good performance.#Elasticsearch #Search #tsvector #pgvector #KNN #Embedding #SentenceTransformers #AI
-
Cải thiện tốc độ tìm kiếm email lên đến 71% với PostgreSQL Full-Text Search
Tìm kiếm email nhanh hơn 59-71% với tsvector và GIN index
Cải thiện hiệu suất tìm kiếm với trọng số và xếp hạng liên quan
#PostgreSQL #FullTextSearch #GINIndex #tsvector #TìmKiếmEmail #HiệuSuất #CảiThiện #Database #Optimization #Vietnamese #English #Tech #Technology #Programming #Developer #Software #EmailSearch #SearchEngine #DatabaseDesignhttps://dev.to/_877737de2d34ff8c6265/how-we-achieved-up-to-71-faster-email-sear