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

I wrote up a blog post about that tsvector and regconfig issue I talk about yesterday. Let me know if it can be followed.

This URL is not permanent.

https://news.freshports.org/?p=1946&preview=1&_ppp=55ebdbbb37

Original post: https://mastodon.social/@dvl/109529523017969879

#postgresql #tsvector

When tsvector was working as expected on most hosts, but not one – FreshPorts News