Re: Quesion about querying distributed databases
| От | Greg Sabino Mullane |
|---|---|
| Тема | Re: Quesion about querying distributed databases |
| Дата | |
| Msg-id | CAKAnmmKiPkxVVTQ6-_MieuroWEnemJQEPLKsLjkdbbub--q2ng@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Quesion about querying distributed databases (me nefcanto <sn.1361@gmail.com>) |
| Ответы |
Re: Quesion about querying distributed databases
|
| Список | pgsql-general |
On Wed, Mar 5, 2025 at 9:44 PM me nefcanto <sn.1361@gmail.com> wrote:
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.
We did. In addition to the ongoing FDW discussion, I mentioned read-only replicas and Citus. As far as *how* to scale vertically, we can offer general advice (more hardware resources, ramdisks for temp stuff, OS-level tuning, separate disk mounts). But a lot of it is tuning Postgres for your specific situation and your specific bottlenecks. Which we are happy to help with. Once we convince you to not throw the baby out with the bathwater. :)
8 Terabytes of data. A single backup took us more than 21 days
Something was fundamentally wrong there.
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
В списке pgsql-general по дате отправления: