5. Usage Considerations : VectorH Limitations
 
Share this page                  
VectorH Limitations
VectorH has the following limitations:
Adding and removing nodes dynamically, and using more or less cores per node are not supported. Nodes can be added or removed with manual intervention. Repartitioning may be needed.
Proper partitioning is essential because non-local queries, especially joins, are expensive.
Deleted space is reclaimed but only if all data of a horizontal split is deleted (by default 1 GB). So worst case scenario, no space is reclaimed; best case scenario, all space is reclaimed. This applies only to data that is deleted through a DELETE statement, not to data deleted through DROP TABLE, MODIFY TO TRUNCATED, or MODIFY TO COMBINE operations, where space is always reclaimed.