Hacker Afternoon Tea

Apr 1, 2022 · Databases

Citus Distributed PostgreSQL: SQL Support Limits and Practical Workarounds

The article explains how Citus extends PostgreSQL to provide distributed tables with full single‑node SQL coverage, enumerates the cross‑node SQL features it cannot handle, and demonstrates concrete workarounds using CTEs and temporary tables with detailed code examples.