With Basic tier, you can be “scale-out-ready” by sharding Postgres on a single Hyperscale (Citus) node and using a distributed data model from the start—so you can easily add nodes later. Or use Basic tier as a handy way to try out Citus. (Preview)
Columnar compression
With the new columnar table storage feature in Hyperscale (Citus), you can compress regular Postgres tables and/or distributed tables to reduce disk footprint, reduce I/O bandwidth needs, and speed up queries. (Preview)
Read replicas
Analysts & developers alike sometimes need to run complex queries without impacting the production database. Read-only replicas of a Hyperscale (Citus) server group are available in the same region. Forks/PITR also available. (Preview)
Managed PgBouncer
Outsource PgBouncer administration to Azure. Allow many clients to connect, while limiting the number of active connections and keeping the coordinator node running smoothly. (Preview)
Postgres releases
Postgres 11, 12, and 13 database versions are all supported. Postgres major version upgrades available with minimal downtime. (Preview)
Easy to Scale
Basic tier
Be “scale-out-ready” by sharding Postgres on a single Hyperscale (Citus) node and using a distributed data model from the start—so you can easily add nodes later. Or use Basic tier as a handy way to try out Citus. (Preview)
Sharding Postgres
Transparently shard Postgres tables across multiple nodes to give your application more memory, compute, and disk. Which gives you parallelism, high performance, and a way to scale. And with Basic tier in Preview, you can also shard Postgres on a single Hyperscale (Citus) node.
Easy to scale up nodes
Easy to increase compute/memory and storage on your Hyperscale (Citus) coordinator & worker nodes.
Easy to add nodes
It’s as simple as moving a slider to add nodes to your Hyperscale (Citus) cluster, whether starting with Basic tier or Standard tier in the Azure Database for PostgreSQL managed service.
Online Shard Rebalancer
When adding nodes to a Hyperscale (Citus) server group, the shard rebalancer enables you to redistribute shards across nodes to better balance the data distribution and the performance of your Citus database. Online, with zero downtime.
Read replicas
Read-only replicas of a Hyperscale (Citus) server group in the same region. Forks/PITR also available. (Preview)
Managed Database Service
High Availability option
HA uses standby replicas for all nodes in a cluster, with streaming replication & automated failover.
Automated backup & restore
Automated backups are stored in multiple Azure availability zones.
Automated monitoring & alerts
Automated monitoring, configurable metrics dashboard, plus alert setup through Azure Monitor.
Security controls
Encryption at rest & in flight, firewall rules, and 2FA.
Pricing
Pay-as-you-go pricing, or prepay with reserved capacity discounts.
Watch a short demo on how to shard Postgres on a single node, so you can start small and seamlessly add nodes to your Hyperscale (Citus) cluster in the future. Umur also demos the new Citus 10 columnar feature, showing >5X compression.
Azure Database for PostgreSQL is a database as a service that you can use to run, manage, and scale PostgreSQL on Azure. This Quickstart will show you how to create a Hyperscale (Citus) server group (aka cluster) in Azure Database for PostgreSQL, using the Azure portal. Along the way, you will get to shard tables across nodes, ingest sample data, and run queries that execute on multiple nodes in a Hyperscale (Citus) server group.
After you’ve checked out the docs, the best next step is to provision a Hyperscale (Citus) server group. Then you get to figure out your distribution key, run the create_distributed_table command, ingest your data, and start assessing how Hyperscale (Citus) performs for your workload.
Citus was a game changer for us. After migrating to Citus, we can onboard Vonto customers 20X faster, in 2 minutes vs. the 40+ minutes it used to take. And with the launch of Hyperscale (Citus) on Azure Database for PostgreSQL, we are excited to see what we can build next on Azure.
Head of Integration of Business Ventures at ASB Bank & Chief Product Officer at Vonto
Are You Ready to Scale Out Postgres with Hyperscale (Citus) on Azure?
