Introducing Hyperscale (Citus) on Azure Database for PostgreSQL. Read the blog.
If you’re looking to scale out your
Break free from the limits of
Ingest & query your database in real time, with
Save time. Run both transactions and analytics in one database. Also, avoid the painful costs of manual sharding
Developed as an open source extension, leverage all your PostgreSQL expertise and its latest innovations
Video of Citus database engineer Marco Slot’s demo at Microsoft Build 2019, showcasing the 2 millisecond query response times using Hyperscale (Citus) and Azure Database for PostgreSQL, even with concurrency of real-time data ingest and 50K queries per second.
Citus was a game changer for us. At ASB, our Vonto service had a vast amount of signups in a short period, causing our single-node Postgres database to creak at the seams—no matter how much we vertically scaled our single node infrastructure. 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.Mathew Stokes, Head of Integration of Business Ventures at ASB Bank & Chief Product Officer at Vonto
No matter how big your data, or how big your data stream, with Hyperscale (Citus) on Azure Database for PostgreSQL, you can always provision enough CPU, memory, and disk to parallelize your workload across a scaled-out Postgres cluster—and give your customers a level of performance you just can’t imagine on a single Postgres node.Marco Slot, Principal Software Engineer, Citus database team at Microsoft
Create an Azure account & sign in to the Azure portal
If you don’t yet have an Azure subscription, this is the first step: create a free account before you begin.
Read the Quickstart docs for Azure Database for PostgreSQL
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.
Provision a Hyperscale (Citus) server group on Azure Database for PostgreSQL
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.
Thank you, we’ll be in touch.