Choosing managed Postgres looks like a pricing decision and turns out to be an operations decision. Every provider runs Postgres competently. They differ on six properties, none of which appear prominently on a pricing page, and all of which you find out about on a bad day.
Here's the list, in the order it'll matter to you. I build PandaStack, which offers managed Postgres on microVMs; I'll name where it sits and where it doesn't fit.
1. What restore actually means
'Automated backups' is not a specification. The questions that matter: how far back does point-in-time recovery reach, what's the recovery point objective — how much data can you lose in the worst case — and how long does restoring your actual data volume take?
The last one is the one nobody measures. A backup you have never restored is a hypothesis. Restore into a scratch database once, with your real data size, and write the number down. That number is your recovery time objective, and it is usually larger than anyone assumed.
2. Connection limits and pooling
Postgres connections are processes and each one costs memory, so small instances have small limits. Modern application architectures are hostile to this: serverless functions open a connection per invocation, ORMs default to a pool per process, and a modest traffic spike exhausts the limit and produces errors that look like a database outage.
Check whether the provider includes a pooler, whether it runs in transaction or session mode — session mode limits how much multiplexing you actually get — and what the effective client limit is through it rather than the raw number on the instance.
3. Extensions
Every multi-tenant managed provider maintains an allowlist, because arbitrary C extensions in a shared instance is not something you can safely offer. That's reasonable, and it's a hard limit when you need something outside the list — a custom extension, a newer version than the provider ships, or anything requiring superuser.
If that's you, the architecture matters more than the vendor: you need a dedicated instance or a database that is its own machine. This is the main reason to look at per-database VM platforms, mine included — when the database has its own kernel, the extension surface is the machine's rather than a shared allowlist.
4. Isolation between databases
For most applications this is not a question. It becomes one when you host per-customer databases and someone asks, during a security review, what stops one customer's workload from affecting another's. 'Separate databases on a shared instance' is a different answer from 'separate instances' which is different again from 'separate virtual machines with their own kernels'.
Also worth knowing for the noisy-neighbour case: on a shared instance, one customer's runaway analytical query is everyone's latency problem.
5. The shape of the pricing, not the number
- Provisioned instances: fixed monthly cost, predictable, wasteful if the database idles most of the week.
- Usage-based compute: excellent for staging, preview branches, and internal tools; a variable version of a fixed cost for a database that's busy around the clock.
- Storage and egress: frequently the surprise line. Check whether backups count toward storage, and what cross-region traffic costs.
- Branch or clone pricing: if branch-per-pull-request is your workflow, find out whether each clone costs a full copy of storage or shares it.
6. What you're expected to do yourself
Managed means different amounts of managed. Ask specifically: who decides when a major version upgrade happens, and can you defer it? Is failover automatic, and what's the observed failover time? Are there read replicas, and is promotion a button or a support ticket? What metrics do you get — connection counts, cache hit ratio, replication lag, slow queries — and can you export them?
The categories
- Hyperscaler managed (RDS, Aurora, Cloud SQL, Azure Database): the dependable default. Deep operational tooling, well-understood failure modes, generous instance sizes, more configuration than a small team wants. Best when you're already in that cloud.
- Serverless Postgres (Neon and similar): storage separated from compute, instant branching, scale-to-zero. Superb for development, preview environments, and idle workloads; check the cold-start behaviour against user-facing traffic.
- Postgres specialists (Crunchy Bridge, Timescale): people who take Postgres seriously, good extension support, straightforward pricing. A strong middle ground.
- Bundled-with-your-PaaS (Render, Railway, Heroku, Fly): maximum convenience, lowest latency to your app, and the tier ladder is where teams eventually run out of room.
- Platform bundles (Supabase): Postgres plus auth, storage, and realtime. Great if you want the platform, more product than necessary if you want a database.
- Per-database virtual machines (PandaStack — mine): each database is Postgres on its own microVM with a durable volume, so compute stays up, the extension surface is the machine's, and isolation is a kernel boundary. Clones restore from the archive into a genuinely independent database, including to a point in time. The trade is that creating one takes tens of seconds rather than being instant — you're provisioning a machine, not a schema.
- Self-managed on a VM: cheapest per gigabyte, and you own backups, failover, patching, and the pager. Fine if you already have an on-call rotation.
# The checks worth running against any provider, before you commit
# 1. What can you actually install?
psql "$DATABASE_URL" -c "SELECT name, default_version, installed_version
FROM pg_available_extensions ORDER BY 1;"
# 2. What is the real connection ceiling?
psql "$DATABASE_URL" -c "SHOW max_connections;"
psql "$DATABASE_URL" -c "SELECT count(*) FROM pg_stat_activity;"
# 3. Restore a point-in-time clone and time it — this number is your RTO
time pandastack db clone prod-db --label restore-drill \
--target-time 2026-08-18T08:00:00ZThe short version
Already deep in one cloud: use its managed Postgres and stop deliberating. Development-heavy workflow with branch-per-PR: serverless Postgres, with the cold-start caveat checked against production traffic. Blocked by an extension allowlist or needing kernel-level isolation per tenant: a per-database VM platform. Small app, one PaaS: use the bundled database until the tier ladder runs out. Whatever you choose, run the restore drill in the first week — it's the only check on this list that tells you something you can't read on a website.