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. You do gain certain kinds of scale, but it’s also a lot of $$$ at smaller scales compared to what a good old fashioned Postgres install will do, and you’ll miss out on other extensions.

Again in particular for databases unless you have expertise already in some of the distributed options I just don’t see a good ROI on choosing them over Postgres.

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 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.

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.