Be Careful with the Sequence CACHE Value
Sarah Lemaire, Manager, Vertica Documentation
June 21, 2018
Jim Knicely authored this tip. The default session cache for a sequence is 250,000. Although you can change the cache value of a sequence, setting the value too low can adversely affect performance! Note that it took 45 seconds to generate 10,000 new sequence values on a 3-node Vertica cluster where sequence cache was 5,...