Resources

This page has many links for you to better understand Citus, how you can use it, learn more about PostgreSQL, get database tips and more technical tutorials for developers to implement Citus.

If this is your first time checking out Citus, we recommend looking at these resources first: Read Introducing Citus 6.0 then watch Scaling your SaaS Database with Postgres.

Citus Overview

• Introducing Citus 6.0
• Introducing Citus Cloud
• Citus Unforks from PostgreSQL, Goes Open Source
• Running Postgres at Scale - PGConfSV 2015 Keynote
• Citus 5.0 Demo
• Announcing Citus MX: Scaling out Postgres to over 500k writes per second
• Citus MX Demo
• Architecture of a cloud database service (Surge 2016)
• Using State Machines to Power Citus Cloud (our Database as a Service)
• Citus Architecture - Extending Postgres to build a distributed database (PGConfUS 16)
• SQL, Scaling, and What's Unique About Postgres

Use Cases

• Scaling Out PostgreSQL for CloudFlare Analytics Using Citus
• Designing a SaaS Database for Scale with Postgres
• Scaling Your SaaS Database with Postgres/Citus
• Sharding a multi-tenant app with Postgres
• Real-time Analytics with Postgres/Citus
• Scaling and Sharding PostgreSQL - Principles and Practice
• Powering Heap Web Analytics
• Parallelizing Analytical Queries in PostgreSQL
• Real-Time Behavioral Analytics with Heap
• BI and Analytics for 2 million websites at Cloudflare
• Interactive Insights to secure trillions of emails at Agari
• Real-time Insights for B2B Sales automation with Mixrank
• Scaling out Postgres for data intensive workloads (PGConf Russia 2015)
• Scalable Real-time Product Search using PostgreSQL with Citus
• Interactive Analytics on GitHub Data (PGDay UK 16)
• Scale out Postgres and Visualize your Big Data (Citus & Chart.io)
• Scalable Postgres as your data platform - Postgres extensions with Citus

PostgreSQL & Database Knowledge

• Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB
• Postgres Autovacuum is Not the Enemy
• Postgres Count Performance
• Improving Postgres' Buffer Manager
• Improving Postgres' concurrency (Postgres Open 2015)
• I/O in Postgres Architecture (PGConf US 16)
• pg_paxos, High Availability Data Replication for PostgreSQL
• pg_paxos: Paxos-based table replication
• Postgres present and future (Pycon 16)
• How to build a distributed database

Tools for Developers

• Hash-distributed Data Tutorial
• Real-time Dashboards
• Ad analytics app using Citus
• Real-time Analytics with Postgres Tutorial
• Cron based job scheduler for Postgres
• Basic implementation of Paxos for a cluster of Postgres nodes
• Packaging scripts for Citus
• Essential Postgres Reference Card