Re: Quesion about querying distributed databases
| От | Rob Sargent |
|---|---|
| Тема | Re: Quesion about querying distributed databases |
| Дата | |
| Msg-id | 025C57B4-F1C3-4533-86FD-D7C85EDCF143@gmail.com обсуждение исходный текст |
| Ответ на | Re: Quesion about querying distributed databases (Igor Korot <ikorot01@gmail.com>) |
| Ответы |
Re: Quesion about querying distributed databases
|
| Список | pgsql-general |
On Mar 5, 2025, at 8:03 PM, Igor Korot jnit worked great for SQL Server. If you're small, we host them all on one server. If you get bigger, we can put heavy databases on separate machines.
However, I don't have experience working with other types of database scaling. I have used table partitioning, but I have never used sharding.Anyway, that's why I asked you guys. However, encouraging me to go back to monolith without giving solutions on how to scale, is not helping. To be honest, I'm somehow disappointed by how the most advanced open source database does not support cross-database querying just like how SQL Server does. But if it doesn't, it doesn't. Our team should either drop it as a choice or find a way (by asking the experts who built it or use it) how to design based on its features. That's why I'm asking.
В списке pgsql-general по дате отправления: