Citus extension already created via CREATE EXTENSION citus.Latest version of Citus, as of time of this writing, Citus 10.0.3.Latest version of Postgres, as of time of this writing, PG 13.

If you prefer, you could instead download Citus open source packages for both single-node and multi-node Citus installations, too.

My favorite way to get started with Citus is to use a docker container to run Citus on a single node. Try out Citus on a single node, with just a few simple commands (a Quick Start guide) And let’s dive deep into some of the ways sharding Postgres on a single node can help you. In this post, let’s walk through how to try out Citus on a single node. No matter what type of application you run on top of Citus-multi-tenant SaaS apps, customer-facing analytics dashboards, time-series workloads, high-throughput transactional apps-there is something for everyone in Citus 10. The Citus 10 release is chock full of new capabilities like columnar storage for Postgres, the open sourcing of the shard rebalancer, as well as the feature we are going to explore here: using Citus on a single node. Simplify CI/CD pipelines by testing with single-node Citus.Shard Postgres on a single Citus node to be “scale-out-ready”.Try out Citus on a single node with just a few simple commands.So in addition to using the Citus extension to Postgres to scale out Postgres across a distributed cluster, you can now also: One of the big new things in Citus 10 is that you can now shard Postgres on a single Citus node. And as always, the Citus database is also available as open source: you can find the Citus repo on GitHub or download Citus here. Update in October 2022: The Citus managed database service is now available in the cloud as Azure Cosmos DB for PostgreSQL.

Node postgres