A database consists of multiple files and can reside in multiple locations. Tables can also be spread across multiple locations.

Updates, inserts, and deletes to the data and the layout of the data in the data files are stored as log information in VWROOT/ingres/data/vectorwise/dbname/wal. The data files and the wal directory must be considered together as files that represent the database.

The data files consist of a number of blocks, which can be seen as the equivalent of pages. Each block contains possibly compressed data from one or more attributes. The size of the block can be configured with the [cbm] block_size parameter (see block_size on page 46) before creating a database.

Also, for better sequential access performance, multiple blocks from the same column can be stored contiguously in a block group. The size of this group can be configured with the [cbm] group_size parameter (see group_size on page 47).

Database size is unlimited because data can be spread across multiple disks. If a table or a column is dropped, its corresponding file or files are deleted and the disk space is reclaimed by the operating system.