I’ve been looking at managed postgres providers. One that looks really great is Aiven and they have hosted postgres on a few different cloud providers (not fly tho). I was wondering if there’s any reason to pick aws vs azure vs gcp vs digitalocean as the host for postgres. Maybe there’s better latency from fly to some cloud providers than others? Better connectivity? Maybe there’s other postgres hosts that do work with fly? I’m looking into a fully managed postgres service, rather than running postgres myself on fly.
Not sure what you mean by “managed”.
Postgres on Fly is the equivalent of another provider’s managed Postgres. With Fly you literally run one command, and it spins up a Postgres cluster, and that’s it, you can connect your app and/or the
psql CLI and run queries.
Other providers that are managed also do this, there’s really nothing more a managed Postgres host will give you unless you mean like automatic vaccuming etc?
Hmm I sort of got the sense from posts like Future of Postgresql on Fly? that I should look into a more managed postgres service than what fly currently provides.
The distinction between “managed” and “automated” (what we call Fly Postgres) is a little fuzzy, but we’re erring on the side of under promising.
Managed usually means someone will get an alert when a service breaks, then drag themselves out of bed and fix the issue. We do manage the infrastructure underneath, but we do not respond to postgres specific issues (like running out of disk space or out of memory errors).
Automated postgres is enough for many apps! It’s very cheap to run, and works well for 99% of users. But some people think it’s worth paying 2-3x the price to have a on call DBAs jump in and fix things if they break. I don’t fault these people, it makes a lot of sense to spend money on that kind of peace of mind.
Aiven does seem great, so does Crunchy Bridge. If you want that level of service, you can happily use these with your Fly apps. For the most part, they’ll be <1ms round trip latency from cities we share with AWS/GCP. Fly.io IAD and AWS us-east-1, for example, work just fine together.
As one of the co-founders of mongohq/compose, I’m sure you have more insight into this… But to be honest, I’d rather not manage any database, automated or self-hosted, for prod apps. It simply isn’t worth it.