Hello, I am looking for experiences / recommendations on worry-free managed PostgreSQL hosting with limitless and effortless horizontal scaling features. Thank you.

[image] acrolink: limitless and effortless horizontal scaling features. Postgres isn’t a technology that does any of those things, at least not all together. It does not effortlessly scale horizontally, and certainly not without limits. Don’t get me wrong, Postgres is amazing. And its vertic…

[image] benwilson512: Don’t get me wrong, Postgres is amazing. And its vertical scaling will get you a long long way. But what you’re asking for isn’t a matter of vendor, it’s a matter of Postgres not being designed to be a horizontally scalable DB. I should have mentioned that I will have to…

A few hundred K points is well within even a small regular Postgres installation. We have IoT data with billions of data points in Postgres and it’s still humming along. I think people underestimate how far you can get without “horizontal” scale at the DB level these days. Aurora is interesting. Yo…

[image] acrolink: Do you know of any other DB system that can be horizontally scalable NewSQL? Cloud Spanner, CockroachDB, YugabyteDB, TiDB, PlanetScale, YDB, Aurora DSQL. Spanner is the only one that offers reasonable consistency guarantees (subject to my personal opinion). Cockroach is the…

[image] benwilson512: Aurora is interesting. You do gain certain kinds of scale Can anyone confirm whether Aurora actually scales further (vertically) than vanilla Postgres? I understand they replaced the storage engine, so I would expect better performance (not like Postgres’s storage engine…

[image] acrolink: Do you know of any other DB system that can be horizontally scalable ? Are you sure that you will need that at all? Because I see that people often say that then need “scale” when their project could fit RPi with room to spare.

Crunchydata is fantastic. Most extensions, high performance, newest versions available almost immediately when they come out and a team of experts you can lean on if you have unique challenges. Works with multiple infrastructure providers as well. Depending on your data model, you can also run th…

[image] brightball: Crunchydata is fantastic. I see they have two solutions: Crunchy Postgres & Crunchy Postgres for Kubernetes Which one you recommend ? or have more experience with ?

The offerings are all essentially the same thing, just a matter of where it’s being deployed. For fully managed, I use Crunchy Bridge. [image] Crunchy Bridge - Managed, Cloud Postgres Cloud-hosted, fully-managed Postgres on AWS, GCP, Azure, or Heroku. Customize performance based on you…

Recommended managed PostgreSQL hosting for Phoenix applications?