VACUUM VERBOSE not working properly with distributed partitions.
- 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
Assessment
This issue has not been assessed yet.