Options
briefly description of v_vertica247_node0003_catalog and v_vertica247_node0003_data
Hi,
i am continuously copying data to flex table. and deleting data after some certain interval from table.
as you have mentioned in documentation,
"Every time you add data to the database, or perform a DML operation, the new data is held in memory (WOS) and moved to storage locations (/path/<databasename>/ )on disk (ROS) at regular intervals".
So, i wanted to know, does it keep all data permanently or the data present in data table(since, in data table we are keeping only few days data).
we are getting space issues on our machine.
i wanted to know does vertica run janitor or any process on v_vertica247_node0003_data to clean up old data.
Thanks for any help.
i am continuously copying data to flex table. and deleting data after some certain interval from table.
as you have mentioned in documentation,
"Every time you add data to the database, or perform a DML operation, the new data is held in memory (WOS) and moved to storage locations (/path/<databasename>/ )on disk (ROS) at regular intervals".
So, i wanted to know, does it keep all data permanently or the data present in data table(since, in data table we are keeping only few days data).
we are getting space issues on our machine.
i wanted to know does vertica run janitor or any process on v_vertica247_node0003_data to clean up old data.
Thanks for any help.
0
Comments
Can you please clarify a bit? Do you mean to ask whether Vertica keeps data in WOS even after moving to ROS, or whether Vertica retains data in persistent storage after data is moved to ROS?
If you want to clean up deleted data to free up disk storage, you can run the following SQL commands to purge all deleted data:
select make_ahm_now();
select purge();
There arn't any janitor jobs to clean up old data unless you add your own scripts, I dont think you would like data to be deleted by itself anyways