3. Database Configuration : Storage Allocation
 
Share this page                  
Storage Allocation
Vector allocates storage on a per column group basis. A column group is defined by the columns that are stored together, which is generally a single column unless you use multi-column indexes, or VECTORWISE_ROW storage. Temporary space is stored in separate temporary files.
Vector files are deleted when the storage space is not required anymore. That is, files for temporary use are deleted when operations finish, and data files are deleted when tables or columns are dropped or tables are truncated.
Note:  Files do not shrink when data is deleted unless the table is truncated. Vector will first reuse empty data blocks in the file before extending it, if there is sufficient consecutive space available in the file.
For more information see the Vector User Guide.