3 ms·
Ask HN: Hosted Postgres provider that offers sharding
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 3y agoI think Azure offers sharding via Citus: https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/introduction 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 3y agoThanks, I found out Pecona does this. I'll check out CockroachDB and Yugabyte.
- franckpachot 3y agoYes, CockroachDB and YugabyteDB do more than sharding, they are distributed SQL (difference here: https://dev.to/yugabyte/partitioning-vs-sharding-what-about-sql-features-4fl1 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