citus
citus copied to clipboard
VACUUM VERBOSE not working properly with distributed partitions.
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)