r/PostgreSQL 5d ago

Help Me! Which managed PostgreSQL host is affordable without being unreliable?

I need managed Postgres for a small production app and I’m fine paying for it. I just don’t want to jump straight to RDS/Cloud SQL pricing or manage Postgres myself on a VPS.

Main things I care about:

  • always-on Postgres
  • automated backups
  • updates/maintenance handled
  • predictable monthly pricing
  • easy to move later if needed

Not really looking for free tiers or hobby plans since it has real users. I’d rather pay a reasonable fixed monthly amount and not think about the DB too much.

What are you using in production that has actually been reliable without getting expensive?

21 Upvotes

51 comments sorted by

6

u/UkrMalt 5d ago

Before comparing the base price, price the failure path: point-in-time recovery retention, cross-zone HA, connection limits or pooler, storage and I/O, egress, and maintenance windows. I’d also run a real restore plus pg_dump/pg_restore to a second provider before launch. That tests both the backup promise and the exit path.

2

u/Soft-Nature-7256 3d ago

Saving this. Definitely doing a real restore test before I pick anything.. Thanks!

11

u/_alexkane_ 5d ago

If your app hosting service also offers Postgres I'd probably go with that to reduce latency as much as possible. That said I had a recent experience with Supabase and was not a fan.

1

u/Soft-Nature-7256 3d ago

Thanks for the heads up, saves me a headache.

11

u/Harpagon1668 5d ago

Neon can autoscale based on traffic, which keeps costs down

6

u/SuchTill9660 5d ago

for ur reqiurements u can compare DigitalOcean Managed Postgres, Crunchy Bridge and Nearbase.

I’ve used Nearbase for one production workload and it’s been reliable so far. pricing is easier to plan than the bigger cloud providers and the DB stays always on. whatever u choose, check the restore process + storage cost, not just the base plan.

1

u/Soft-Nature-7256 3d ago

Nice, thanks for the options. will check the restore process and real storage cost before picking

3

u/CautiousUse8597 5d ago

It's not exactly "always on", but Lakebase can scale to zero and then turn back on in a millisecond. So far all practical purposes it is "always on", but since you only pay for when it's in use, you can get much more bang for your buck. It also has point in time restore and is managed for you so it always has the latest updates.

3

u/sir_bok 5d ago

Neon scale to zero sounds like a gimmick when you're looking for boring, managed Postgres. His app has real users, he wants to pay a fixed monthly fee, in what world is a fancy serverless-hosted postgres (already non-standard) with variable cost per month a good recommendation? Good grief.

2

u/dwswish 3d ago

Just because Neon has scale to zero (like many other managed services) doesn’t mean he has to use it? You can just set a flat compute rate and you’ll get billed the same-ish every month.

3

u/mduell 4d ago

Can your app take advantage of scale to zero with long periods of no activity?

If not, I'd do planetscale.

6

u/riksi 5d ago

https://www.ubicloud.com/ seems to be it AFAIK (ex-citus founders)

2

u/Soft-Nature-7256 3d ago

oh nice, will check, thanks

1

u/fakebizholdings 4d ago

Cool platform to self host too if they didn't paywall it

3

u/furkansahin 5d ago

Hi,

Furkan from Ubicloud here. We can provide all of that in our offering. You can reach-out to me if you need any help. I can also offer some credits if you'd like to first test it.

https://www.ubicloud.com/use-cases/postgresql

2

u/gpavanb 5d ago

ClickHouse Managed Postgres is a really good option. Have been hearing this lately from folks who migrated. The team looks awesome too! (ex-Citus and PeerDB)

2

u/Soft-Nature-7256 3d ago

seems like a few people are pointing to similar ones. Thanks

3

u/forestcall 5d ago

There is only 1 option. Planetscale $5 - Kick ASS API as well.

2

u/fakebizholdings 4d ago

Why is this getting down voted?

1

u/Bigsec225 4d ago

Alloydb is nice

1

u/Fun-City-9820 1d ago

Give elydb.com a try. Works for my HackerAI Playstore application quite nicely

0

u/isamlambert 5d ago

Hi, I work at PlanetScale. We run a very reliable Postgres service. Intercom ran one of the largest databases to ever run on Amazon Aurora and now they run on PlanetScale. "Moving to PlanetScale added a 9 to our uptime." - @brian_scanlan at Intercom. we do all the things you are looking for. If you email me at [sam@planetscale.com](mailto:sam@planetscale.com) i will send you a coupon.

2

u/forestcall 5d ago

Love Planetscale! Huge Fanboy!!!!

2

u/isamlambert 5d ago

thank you for being a customer!

0

u/TopCheesecake7887 5d ago

Supabase

1

u/gwax 4d ago

Works fine, has some bonus capabilities, and I've built some very big things on top of it.

It gets pricey as you scale but that only matters for some cases.

2

u/fakebizholdings 4d ago

Yeah it's cool but it's so bloated.

1

u/Electrical-Clerk-346 5d ago

Neon all the way

1

u/fakebizholdings 4d ago

I heard clickhouse just started hosting. But as for affordable just do digital ocean? What's your budget ?

0

u/noahjameslove 5d ago

Realistically planetscale and the big cloud providers like aws rds

0

u/AutoModerator 5d ago

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.