How to measure the Size of your HP Vertica Database Catalog
This script will show you what is the size of you Database Catalog.
Use this information to set your General Resource Pool accordingly by keeping in mind that the Vertica Catalog is not loaded in the General Pool allocated Memory and is loaded into the memory that is outside the General Pool allocated Memory threshold.
SELECT node_name
,max(ts) AS ts
,max(catalog_size_in_MB) AS catlog_size_in_MB
FROM (
SELECT node_name,trunc((dc_allocation_pool_statistics_by_second."time")::TIMESTAMP, 'SS'::VARCHAR(2)) AS ts ,sum((dc_allocation_pool_statistics_by_second.total_memory_max_value - dc_allocation_pool_statistics_by_second.free_memory_min_value)) / (1024 * 1024) AS catalog_size_in_MB
FROM dc_allocation_pool_statistics_by_second
GROUP BY 1,trunc((dc_allocation_pool_statistics_by_second."time")::TIMESTAMP, 'SS'::VARCHAR(2))
) foo
GROUP BY 1
ORDER BY 1;
