Display Session Sequence Cached Values Remaining
Jim Knicely, Big Data Solutions Architect, Vertica
April 17, 2019
To optimize the performance of large INSERT SELECT and COPY operations, Vertica uses sequence caching. To allocate cache among the nodes in a cluster for a given sequence, Vertica uses the following process: By default, when a session begins, the cluster initiator node requests cache for itself and other nodes in the cluster. The initiator...