The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Configure data retention for the sources of the load_streams system table ..

marcothesanemarcothesane Employee Employee

Hi All -

I'm trying to ensure that the load_streams system table has 3 days' worth of data at all times.

I just tried:

SELECT GET_DATA_COLLECTOR_TIME_POLICY(
  'v_monitor.load_streams'
, '3 days'::INTERVAL
);

Then, as this is the only 3-days' setting I ever did on this new database, I tried:

select 
  component
 ,interval_time
 , memory_buffer_size_kb
 , disk_size_kb 
from v_monitor.data_collector 
where interval_time='3 00:00:00.000000;

And got:

component               |interval_time    |memory_buffer_size_kb|disk_size_kb
Errors                  |3 00:00:00.000000|                1,000|      10,000
ExecutionEngineProfiles |3 00:00:00.000000|                2,000|      50,000
ExecutionEngineResources|3 00:00:00.000000|                2,000|      50,000
ProjectionsUsed         |3 00:00:00.000000|                2,000|     150,000
RequestsCompleted       |3 00:00:00.000000|                2,000|      50,000
RequestsIssued          |3 00:00:00.000000|                2,000|      50,000

Question now is: Do I need to modify memory_buffer_size_kb and/or disk_size_kb to make sure I get 3 days' worth of data, even if I get more data than those values state, or does the 3 day interval simply override everything?

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.