Logo Citus Docs
v7.2

About Citus

  • What is Citus?
  • Concepts

Installation

  • Requirements
  • Single-Machine Cluster
  • Multi-Machine Cluster

Tutorials

  • Multi-tenant Applications
  • Real-time Analytics

Distributed Data Modeling

  • Determining Application Type
  • Distributing Data
  • Table Co-Location

SQL Reference

  • Creating and Modifying Distributed Tables (DDL)
  • Ingesting, Modifying Data (DML)
  • Querying Distributed Tables (SQL)
  • PostgreSQL extensions

Transitioning to Citus

  • Multi-tenant Data Model
  • Real-Time Analytics Data Model

Performance

  • Citus Query Processing
  • Scaling Out Data Ingestion
  • Query Performance Tuning

Cloud

  • Getting Started
  • Scaling
  • Security
  • Availability and Recovery
  • Additional Features
  • Monitoring
  • Logging
  • Support and Billing

Use-Case Guides

  • Multi-tenant Applications
  • Real Time Dashboards

Administration

  • Cluster Management
  • Table Management
  • Production Sizing
  • Upgrading Citus

Reference

  • Citus SQL Language Reference
  • SQL Workarounds
  • Citus Utility Function Reference
  • Metadata Tables Reference
  • Configuration Reference
  • Commonly Encountered Error Messages
  • Append Distribution

Articles

  • Introducing Citus Add-on for Heroku: Scale out your Postgres
  • Efficient Rollup Tables with HyperLogLog in Postgres
  • Distributed Distinct Count with HyperLogLog on Postgres
  • How to Scale PostgreSQL on AWS: Learnings from Citus Cloud
  • Postgres Parallel Indexing in Citus
  • Real-time Event Aggregation at Scale Using Postgres with Citus
  • How Distributed Outer Joins on PostgreSQL with Citus Work
  • Designing your SaaS Database for Scale with Postgres
  • Building a Scalable Postgres Metrics Backend using the Citus Extension
  • Sharding a Multi-Tenant App with Postgres
  • Sharding Postgres with Semi-Structured Data and Its Performance Implications
  • Scalable Real-time Product Search using PostgreSQL with Citus

FAQ

  • Frequently Asked Questions
Citus Docs
  • »
  • Citus Documentation
  • Edit on GitHub

Citus DocumentationΒΆ

Welcome to the documentation for Citus 7.2! Citus horizontally scales PostgreSQL across commodity servers using sharding and replication. Its query engine parallelizes incoming SQL queries across these servers to enable real-time responses on large datasets.

Getting Started

Learn the Citus architecture, install locally, and follow some ten-minute tutorials.

Use Cases

See how Citus allows multi-tenant applications to scale with minimal database changes.

Migrating to Citus

Move from plain PostgreSQL to Citus, and discover data modeling techniques for distributed systems.

Citus Cloud

Explore our secure, scalable, highly available database-as-a-service.

API / Reference

Get the most out of Citus by learning its functions and configuration.

Help and Support

See the frequently asked questions, and contact us. This is the page to get unstuck.
_images/number-one.png _images/use-cases.png _images/migrating.png _images/cloud.png _images/reference.png _images/help.png _images/logo.png
Next

© Copyright 2022, Citus Data. Revision 5a169af2.

Read the Docs v: v7.2
Versions
latest
stable
v11.0-beta
v10.2
v10.1
v10.0
v9.5
v9.4
v9.3
v9.2
v9.1
v9.0
v8.3
v8.2
v8.1
v8.0
v7.5
v7.4
v7.3
v7.2
v7.1
v7.0
v6.2.2
v6.2
v6.1
v6.0
v5.2
v5.1
v5.0
a11y-2
Downloads
pdf
html
epub
On Read the Docs
Project Home
Builds