Vertica Segmentation

Vertica optimizes the database by distributing data across cluster using Segmentation. What segmentation does:

  • Segmentation -places a portion of data on a node .
  • will evenly distribute data on all nodes.
  • this way each node will perform a piece of the querying process. The query will be run on the cluster and every node will receive the query plan,the results of the queries are aggregated and used to create the output.
The job of segmentation is to distribute data evenly across multiple database nodes so that all nodes can participate in query execution. segmentation In the image we can see an example of data segmentation that Vertica implements. We can see that data is segmented by hash on all nodes. The distribution of data into blocks across the cluster will enable fast query processing.