How to Distribute Postgres Geographically

Re:How to Distribute Postgres Geographically by Ozzie_osman on Sunday June 02, 2024 @11:24AM (#40554896)

Thanks for this commentary! At a startup where we are preparing to shard Postgres. I'd be curious if you're familiar with AWS limitless, and how you would have approached deciding whether to use it vs. the approach in the blog post had it existed back in 2021.

[ Parent | on HN ]

Re:How to Distribute Postgres Geographically by jitl on Sunday June 02, 2024 @12:14PM (#40555244)

I’m a solid “no” on any primary datastore database thingy that’s under 5 years of industry wide production workload experience, and would seriously weigh it against something with 10+ years industry use.

In 2019 when I was interviewing at companies for my next position I heard from a few places that the original Aurora for Postgres lost their data. It seems like the sentiment on mainline Aurora has improved a bit, but I would never bet my company’s future on an AWS preview technology.

[ Parent | on HN ]

Re:How to Distribute Postgres Geographically by dilyevsky on Monday June 03, 2024 @12:56PM (#40564594)

What about CockroachDB? There are real-world, large-scale deployments of it (e.g Netflix) going back more than 5 years easy.

[ Parent | on HN ]

Re:How to Distribute Postgres Geographically by jitl on Tuesday June 04, 2024 @04:50PM (#40578799)

It might be a good choice, I don't know enough about either the technology or the market for CockroachDB expertise.

[ Parent | on HN ]

Re:How to Distribute Postgres Geographically by sgarland on Sunday June 02, 2024 @11:44AM (#40555038)

My biggest concern with Limitless – other than inherent performance issues with Aurora – is that according to their docs, it’s built on Aurora Serverless. IME, Serverless anything tends to get absurdly expensive very quickly.

[ Parent | on HN ]