Ask HN: Hosted Postgres provider that offers sharding

4 pointsrtukpe3 comments

Hi HN,

Does anyone know a DBaaS provider that provides Postrges clusters with the option to shard them down the line? Most providers I currently know don't offer features beyond replication and connection pooling.

Would love any help, thanks in advance.

View on HN

I think Azure offers sharding via Citus: https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql...

Then, there's the Postgres compatible offerings like CockroachDB and Yugabyte that do sharding transparently.

Thanks, I found out Pecona does this. I'll check out CockroachDB and Yugabyte.

Yes, CockroachDB and YugabyteDB do more than sharding, they are distributed SQL (difference here: https://dev.to/yugabyte/partitioning-vs-sharding-what-about-...). YugabyteDB is open source and has more postgres features as its query layer is a fork of postgres, but good to test both

Reply on news.ycombinator.com