Limit of 1 TB to compressed or uncompressed storage

Engineer1111Engineer1111 Registered User

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,
anchor_table_name,
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
FROM v_monitor.column_storage
GROUP BY anchor_table_schema,
anchor_table_name
ORDER BY SUM(used_bytes) DESC;

Comments

Leave a Comment

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