Postgres and Citus
What is Citus?
Citus is an open source PostgreSQL extension that transforms Postgres into a distributed database—so you can achieve high performance at any scale.
Learn more and stay connected with the Citus open source project:
- citusdata/citus (github.com)
- docs.citusdata.com
- Twitter: @citusdata | @AzureDBPostgres | @marcoslot
- Citus Newsletter - subscribe to the monthly newsletter with links to favorite Citus & Postgres articles
- Citus Public Slack - for community & developer Q&A
Try Citus
The smallest possible Citus cluster is a single PostgreSQL node with the Citus extension, which means you can try out Citus by running a single Docker container.
# run PostgreSQL with Citus on port 5500
docker run -d --name citus -p 5500:5432 -e POSTGRES_PASSWORD=mypassword citusdata/citus
# connect using psql within the Docker container
docker exec -it citus psql -U postgres
# or, connect using local psql
psql -U postgres -d postgres -h localhost -p 5500
Or if you prefer to download Citus open source packages and install locally, that’s easy too.
The quickest way to get started with Citus in the cloud is to use Hyperscale (Citus), a built-in option in the Azure Database for PostgreSQL managed service (see: Quickstart on docs.microsoft.com).
And if you want to learn a bit more before diving in, we’ve curated our favorite getting started resources online, so you can learn your way.
What’s new & spectacular in Citus 10
Blog - Citus 10: Columnar for Postgres, rebalancer, single-node, & more (citusdata.com)
Deep dive blog posts:
- Columnar compression
- Open source shard rebalancer
- Citus on a single node
Demo - Citus 10 brings columnar to Postgres (youtube.com) with Jeff Davis
Demo - High performance HTAP with Postgres & Hyperscale (Citus) (youtube.com) with Marco Slot