How to Avoid Propagation
During batch operations Vector automatically propagates the changes buffered in memory to the disk-resident table. Because such propagation can be costly in terms of time and resources, it is best to avoid frequent propagation to large tables by using one of the following approaches:
• Consider disabling automatic propagation by setting [system] update_propagation = false.
• For tables with a clustered index, keep the volume of data changed below what will easily fit in RAM.
Note: The data changes buffered in memory are not compressed.