6 ms·
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 oth
by ComputerGuru 9mo ago
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.
- dalberto 9mo agoI generally agree that one database instance is ideal, but there are other reasons why Postgres everywhere is advantageous, even across multiple instances: - Expertise: it's just SQL for the most part - Ecosystem: same ORM, same connection pooler - Portability: all major clouds have managed Postgres I'd gladly take multiple Postgres instances even if I lose cross-database joins.
- throwaway7783 9mo agoYep. If performance becomes a concern, but we still want to exploit joins etc, it's easy to set up replicas and "shard" read only use cases across replicas.
- nicholasjarnold 9mo agoPostgres supports the Foreign Data Wrapper concept from SQL/MED. If you configure this you can do joins across instances, even! https://www.postgresql.org/docs/current/postgres-fdw.html https://www.postgresql.org/docs/current/postgres-fdw.html