Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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?

SELECT anchor_table_schema,
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
FROM v_monitor.column_storage
GROUP BY anchor_table_schema,
ORDER BY SUM(used_bytes) DESC;


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.