Ask HN: Hosted Postgres provider that offers sharding

[rtukpe]

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.

[tudorg]

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.

[rtukpe]

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

[franckpachot]

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