Lab 2 — Investigate How the fleets Table Is Stored¶
Module reference: Module 03 — Citus Architecture
Goal¶
The fleet database contains a fleets table — one row per fleet operator
(10,000 fleets; fleet 1 is Metro Cabs, 2 is Harbor Logistics, 3 is
Golden Gate Rides).
Before changing anything, work out how the cluster currently manages this table. Collect three pieces of evidence:
- Does Citus recognise
fleetsas one of the tables it manages, and if so of what type? - Do any shards exist for
fleets, and on which worker nodes do they live? - How many rows does
fleetsreturn when you query it through thecoordinator?
Background¶
A table in a Citus cluster can be in one of three states:
| State | Meaning |
|---|---|
| Local | An ordinary PostgreSQL table living only on the coordinator. Citus doesn't manage it. |
| Distributed | Sliced into shards; rows spread across workers by the distribution column. |
| Reference | Copied in full to every worker (used for small lookup/dimension tables). |
The catalogue view citus_tables lists everything Citus manages. The view
citus_shards lists every shard of those tables and where each is placed.
Visual guide — locate the rows¶
The letters represent illustrative rows, not your query results. Compare the three storage patterns with the metadata you collect below.
Connect¶
Step 1 — Is fleets a Citus-managed table?¶
Query citus_tables for fleets:
SELECT table_name, citus_table_type, distribution_column, shard_count
FROM citus_tables
WHERE table_name = 'fleets'::regclass;
Step 2 — Do shards exist for fleets?¶
Query citus_shards for fleets and note the worker each shard is on:
SELECT table_name, shardid, shard_name, nodename, nodeport
FROM citus_shards
WHERE table_name = 'fleets'::regclass;
Step 3 — How many rows?¶
Question¶
Based on the three pieces of evidence, how is the fleets table currently
stored — local, distributed, or reference? Justify your answer from what you
observed.
Checkpoint¶
- You can name the catalogue views that answer "is this table distributed?" and "where are its shards?".
- You noticed that a local table still returns all its rows through the coordinator — "not managed by Citus" does not mean "empty".
Next: Lab 3 — Distribute the fleets table
Stuck? See solutions/lab-02-solutions.md.