Limit of 1 TB to compressed or uncompressed storage
We are using Vertica community edition which comes with 1 TB of free storage. Is this limit based on the compressed or uncompressed storage?
Also i think this gives me the compressed space utilized by a table, how to get the uncomressed storage?
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
GROUP BY anchor_table_schema,
ORDER BY SUM(used_bytes) DESC;