citusdata / citusdata/citus

VACUUM VERBOSE not working properly with distributed partitions.

Open
#6,198 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

Got a question about timeseries partition and sharding.
I created a distributed table partitioned by create time. Then I archived the table with Columnar stroage.
After that, I tried VACUUM VERBOSE the table. The result is weird:
```
statistics for "test_table_p2022_08_17":
storage id: 10000002515
total file size: 16384, total data size: 0
compression rate: 1.00x
total row count: 0, stripe count: 0, average rows per stripe: 0
chunk count: 0, containing data for dropped columns: 0
```
There are 10M data in there. And I did verify that the data was compressed from 3G to 1.2G. So it's strange that VACUUM VERBOSE show no data in there. Is that because the table is both partitioned and sharded so the vacuum command is not working?
By the way the following commands shows the total size of disk used:
```
SELECT pg_size_pretty(citus_relation_size('test_table_p2022_08_17'));
1238 MB (edited)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.