alt Hacker NewsAre you using a dedicated pg instance for vector or you keep all your data in a single pg instance (vector and non-vector)?
Replies
ricw • last Tuesday at 7:59 PM
All in one of course. That’s the biggest advantage. And why postgres is great - it covers virtually all standard use cases.
The biggest selling point to using Postgres over qdrant or whatever is that you can put all the data in the same db and use joins and ctes, foreign keys and other constraints, lower latency, get rid of effectively n+1 cases, and ensure data integrity.