Tagged articles

TopN

5 articles · Page 1 of 1
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 29, 2022 · Databases

Using Citus for Distributed PostgreSQL: SQL Reference for Querying Distributed Tables

This article explains how Citus extends PostgreSQL for distributed execution, detailing supported aggregation functions, count‑distinct handling, HyperLogLog columns, Top‑N estimation, percentile sketches with t‑digest, limit push‑down, view support, and various join strategies, while providing concrete SQL examples and configuration tips.

AggregationCitusDistributed SQL
0 likes · 16 min read
Using Citus for Distributed PostgreSQL: SQL Reference for Querying Distributed Tables