Vertica Blog

Vertica Blog

WOS

WOS ROS differences

Write Optimized Store (WOS) Deprecation – What You Need to Know

Sumeet Keswani, Vertica Product Technology Engineer
March 23, 2020

In Vertica 10.0, WOS (Write Optimized Store) will be deprecated. In this blog, we introduce the historical justification for WOS and its purpose, why we believe that it's no longer needed, and our justification for deprecating it. We'll go over the data and the testing we performed that gives us the confidence to ensure that...
Helpful Tips message on post-it note

DIRECT Is Now the Default Load Type

James Knicely, Vertica Field Chief Technologist
October 19, 2019

Write Optimized Store (WOS) is a memory-resident data structure for short-term data storage while Read Optimized Store (ROS) is a highly optimized, read-oriented, disk storage structure, organized by projection. Prior to Vertica 9.3, by default, Vertica initially loads data into WOS. For databases created in version 9.3 and later, Vertica now uses a default load...
Modern Database Analytics

Understanding ROS and WOS: A Hybrid Data Storage Model

Sarah Lemaire, Manager, Vertica Documentation
October 7, 2015

Vertica is unique in many ways, one of which can be seen in its data storage model. In this blog, we?ll go over each storage component and show you how to take advantage of Vertica?s storage options to optimize your database for writing and reading.