Propagate In-memory Updates to Disk
During batch operations Vector automatically propagates the changes buffered in memory to the disk-resident table.
To do this manually, use the MODIFY...TO COMBINE statement. Doing so frees this memory, which is shown as memory.update_allocated in the vwinfo output.
Use the following SQL statement:
MODIFY table_name TO COMBINE