Ask HN: Hosted Postgres provider that offers sharding

Posted by rtukpe on Wednesday August 30, 2023 @08:22AM
from the ask-hn dept.

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.

( 3 comments | 2 points | on HN )

Re:Ask HN: Hosted Postgres provider that offers sharding by tudorg on Wednesday August 30, 2023 @08:28AM (#37320991)

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.

[ Parent | on HN ]

Re:Ask HN: Hosted Postgres provider that offers sharding by rtukpe on Wednesday August 30, 2023 @12:16PM (#37324299)

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

[ Parent | on HN ]

Re:Ask HN: Hosted Postgres provider that offers sharding by franckpachot on Monday September 04, 2023 @03:29AM (#37378044)

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

[ Parent | on HN ]