Was this helpful?
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 X100_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 enough consecutive space available in the file.
For more information see the Vector User Guide.
 
Last modified date: 11/09/2022