The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Question for WOS and ROS
HI, from the Vertica documentation I got to know that insert statement(without direct distinct) will load data to WOS first, then the tuple move will merge the WOS data to ROS files, when we read data by exeucting select, it will always read data from ROS since the data in ROS is sorted. But Tuple move will merge data every 10 minutes by default, that means if I insert a record in to WOS, I might have to wait 10 minutes so that i could get it from select statement only after 10 minutes, actually, this is not the case, so I'm wondering maybe some of my understanding from the documentation is wrong? Thanks.