Citus Con: An Event for Postgres is a wrap! 💥 Thanks to all who joined. If you missed the event, you can still find and watch all 38 recorded talks 🖥 online.
Citus Con: An Event for Postgres is a wrap! 💥 Thanks to all who joined. If you missed the event, you can still find and watch all 38 recorded talks 🖥 online.
Citus is available in the cloud as Hyperscale (Citus), a
Scale out Postgres by distributing your data & queries across a cluster. And it’s simple to add nodes & rebalance shards when you need to grow.
Speed up queries by 20x to 300x (or more) through parallelism, keeping more data in memory, higher I/O bandwidth, and columnar compression.
Run Citus in the cloud with Hyperscale (Citus), a
Reduce your infrastructure headaches by using a single database for both your transactional and analytical workloads.
With Private access, you can allow hosts on a virtual network (VNet) to securely access a Hyperscale (Citus) server group over a private endpoint.
Postgres 11, 12, and 13 database versions are all supported. Postgres major version upgrades now available with minimal downtime. And as of Oct 2021, Postgres 14 is supported in many Hyperscale (Citus) regions too.
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.
With the new columnar 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.
In addition to features like columnar compression and basic tier, the latest release of Citus 10 is now available in many Hyperscale (Citus) regions and will roll out to remaining regions in the coming months.
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.
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, you can also shard Postgres on a single Hyperscale (Citus) node.
Easy to increase compute/memory and storage on your Hyperscale (Citus) coordinator & worker 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.
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.
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.
Outsource PgBouncer administration to Azure. Allow many clients to connect, while limiting the number of active connections and keeping the coordinator node running smoothly.
High availability (HA) avoids database downtime by maintaining standby replicas for all nodes in a Hyperscale (Citus) cluster, with streaming replication & automated failover.
Automated backups are stored in multiple Azure availability zones. Point-in-time restore is available for any point in time in the last 35 days. Learn more about backup and restore in the Azure docs.
Automated monitoring, configurable metrics dashboard—plus alert setup through Azure Monitor just like with other Azure services.
Periodic maintenance is included in the service to keep your managed database secure, stable, and up-to-date. You can select your scheduled maintenance windows or let the system pick a day and time window for you automatically.
Security features in Hyperscale (Citus) include: Encryption at rest & in flight, firewall rules, and 2FA. For networking, you can use public access with public IPs, private access with private endpoints—or enable both together.
Pay-as-you-go pricing, or prepay with reserved capacity discounts. Learn more on the Hyperscale (Citus) pricing page.
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.
Looking for Citus open source? Download Citus packages