3 ms·

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

by tudorg 3y ago

I 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 ago
Thanks, I found out Pecona does this. I'll check out CockroachDB and Yugabyte.
- franckpachot 3y ago
  Yes, 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