citus_docs icon indicating copy to clipboard operation
citus_docs copied to clipboard

Document clearing data from coordinator

Open colton-citus opened this issue 6 years ago • 2 comments

If user takes the following steps, data will be left on coordinator:

  1. Create table
  2. Load data
  3. Distribute table

Fix:

SET citus.enable_ddl_propagation TO false;
TRUNCATE TABLE target_table;
SET citus.enable_ddl_propagation TO true;

colton-citus avatar Jul 15 '19 20:07 colton-citus

The broader use case is when someone happened to load the data onto the coordinator prior to distributing it, and now wants to reclaim space on the coordinator?

I should check that we recommend distributing tables before loading data, and if not then I should probably update those instructions.

jonels-msft avatar Aug 20 '19 21:08 jonels-msft

Yes, that is correct. I'd also suggest adding a warning and clearing steps so this doesn't surprise customers too often.

colton-citus avatar Aug 20 '19 22:08 colton-citus