Showing posts with label WOS vs ROS. Show all posts
Showing posts with label WOS vs ROS. Show all posts

Thursday, June 23, 2016

Vertica Storage model

Hybrid Storage Model

This model is the same on each HP Vertica node.
Storage Model
Write Optimized Store (WOS) - memory ( stored as row-store unsorted , uncompressed)
Read Optimized Store (ROS)- Disk
Tuple Mover (TM) - Moves data from memory to Disk ( Stored as column store, sorted and compressed )
With /*+direct*/ hints , Bypass WOS.