Citus 11.x Distributed PostgreSQL: Complete SQL Reference Guide

SQL Reference

Creating and modifying distributed objects (DDL)

Reference: https://citus.hacker-linner.com/develop/reference_ddl.html

Creating distributed tables

Reference tables

Distributed coordinator data

Co-located tables

Upgrade from Citus 5.x

Dropping tables

Altering tables

Add/modify columns

Add/drop constraints

Use NOT VALID constraints

Add/drop indexes

Types and functions

Manual modifications

Ingesting and modifying data (DML)

Reference: https://citus.hacker-linner.com/develop/reference_dml.html

Inserting data

"From Select" clause (distributed rollups)

COPY command (bulk loading)

Using rollup cache aggregation

Reference: https://citus.hacker-linner.com/develop/reference_dml.html#rollups

Update and delete operations

Maximizing write performance

Querying distributed tables (SQL)

Reference: https://citus.hacker-linner.com/develop/reference_sql.html

Aggregate functions

COUNT(DISTINCT) aggregation

Estimating Top‑N items

Percentile calculations

Limit push‑down

Views on distributed tables

Joins

Co-located joins

Reference table joins

Repartition joins

Query processing

Reference: https://citus.hacker-linner.com/develop/reference_processing.html

Distributed query planner

Distributed query executor

Sub‑query/CTE push‑pull execution

PostgreSQL planner and executor

Manual query propagation

Reference: https://citus.hacker-linner.com/develop/reference_propagation.html

Run on all workers

Run on all shards

Limitations

SQL support and workarounds

Reference: https://citus.hacker-linner.com/develop/reference_workarounds.html

Workarounds

Using CTEs to overcome limitations

Temporary tables as a last‑resort solution

Further Reading

Try Citus 11.0 beta (official blog) – http://mp.weixin.qq.com/s?__biz=MzA4Mzc4NTE5MQ==∣=2692296184&idx=1&sn=8f75bf18483b3333490fb30269e03ddb&chksm=ba7ca9708d0b2066692a6330c1eb6759dd95beea546ad3a870247e51ae74e6fb2cfc84cb863e&scene=21#wechat_redirect

ASP.NET Core + SaasKit + PostgreSQL + Citus multi‑tenant application example – http://mp.weixin.qq.com/s?__biz=MzA4Mzc4NTE5MQ==∣=2692296171&idx=1&sn=da45d1f34cc3b1265b0dd8273890190f&chksm=ba7ca9638d0b207508d713dc535cbf285b9aa9acf9b366302e6faa8284f5a06e6786529661fd&scene=21#wechat_redirect

Original documentation: https://citus.hacker-linner.com