The ANN index IVF implemented in pgvector has very poor performance, with only around 50% recall. Is it a good enough reason, or you don't care about results accuracy in favor of the comfort of using a multitool?
You can do everything with PostGres:
Full-text search, but there are better engines for it: Elastic, Meilisearch, etc. right?
You can also store JSON into Postgres, but you should better use MongoDB for NoSQL purposes, right?
The reason for this is: dedicated tools are always better, faster, and more feature-rich.
You can do everything with PostGres: Full-text search, but there are better engines for it: Elastic, Meilisearch, etc. right?
You can also store JSON into Postgres, but you should better use MongoDB for NoSQL purposes, right?
The reason for this is: dedicated tools are always better, faster, and more feature-rich.