Lets consider the below table as an example:
CREATE TABLE SCHEMA.TABLE_X( ID INTEGER, NAME VERCHAR2(255)) ;
After creating the table we have inserted the records and when we check the total count of our table we see there are 10 rows present in the table.
Then we have issued the below DMLs:
INSERT INTO SCHEMA.TABLE_X VALUES(1,'X');
INSERT INTO SCHEMA.TABLE_X VALUES(1,'X');
INSERT INTO SCHEMA.TABLE_X VALUES(1,'X');
INSERT INTO SCHEMA.TABLE_X VALUES(1,'X');
INSERT INTO SCHEMA.TABLE_X VALUES(1,'X');
COMMIT;
As per Vertica concepts we know, data is moved from WOS and then to ROS after the moveout operation.
By default the moveout time is 300 secs.
But in this case after we insert 5 records in our table "TABLE_X" and then after issueing the below query:
SELECT COUNT(1) FROM SCHEMA.TABLE_X;
I could see there are in total 15 rows.
Now my doubt is the moveout operation is supposed to happen at an interval of 300 secs, how the data move from WOS to ROS.
Could you please clarify my doubt?
Thanks,
Kushal