cache-no-cache-parameter.md
Whether to cache unique sequence numbers on each node for faster access. CACHE takes an integer argument as follows:
-
>1 specifies how many unique sequence numbers are pre-allocated and stored in memory for faster access. Vertica sets up caching for each session, and distributes it across all nodes.
Caution
If sequence caching is set to a low number, nodes are liable to request a new set of cache values more frequently. While it supplies a new cache, Vertica must lock the catalog. Until Vertica releases the lock, other database activities such as table inserts are blocked, which can adversely affect overall performance. -
0 or 1 specifies to disable caching (equivalent to
NO CACHE).
By default, the sequence cache is set to 250,000.
For details, see Distributing sequences.