Hacker Afternoon Tea

Mar 28, 2022 · Databases

Citus Distributed PostgreSQL: Inserting, Updating, and Deleting Data (SQL Reference)

This guide explains how to use standard PostgreSQL INSERT, multi‑row INSERT, INSERT … SELECT, COPY for bulk loading, upserts with ON CONFLICT, and UPDATE/DELETE on Citus‑distributed tables, including routing by distribution column, performance tips, and two‑phase commit considerations.